Automatic Triggering not working
SELECT * FROM DRLMulticompany.dbo.tbl_Orders AS os
INNER JOIN DRLMulticompany.dbo.tbl_order_details AS od
At this point it should trigger - I have even tried adding . and os. as trigger words but does not work - I have to press Ctrl + Space to trigger manually
In fact is not working after any . and is very temperamental triggering on table names and db names (Having to space then delete for the trigger to work). It used to work fine before installing Microsoft SDK for server 2008 (Which has now been uninstalled. I have uninstalled sql prompt and re-installed - Also deleting the settings held in AppData) I have version 3.9 on Vista running sql server 2008.
I have compared all settings with a colegue and all are exactly the same - His however works fine