Menu
New version of Management Studio (i.e. the one that ships with SQL Server 2008) finally has a Transact-SQL IntelliSense feature. However, out-of-the-box it only works with SQL Server 2008 instances.
Is there some workaround for this?
863
On the Tools menu, click Options. Expand Text Editor, expand Transact-SQL, and then click IntelliSense.
The first step of troubleshooting IntelliSense is to check and make sure IntelliSense is enabled in the settings. Launch SSMS and go to menu Tools >> Options. In the Options window, expand TextEditor >> Transact-SQL >> IntelliSense. Make sure Enable IntelliSense is selected.
Select the Edit menu, select IntelliSense, then select Refresh Local Cache. Use the CTRL+Shift+R keyboard shortcut.
Click the 'Complete Word' button on the Text Editor toolbar. In the Edit menu, point to IntelliSense, and then click 'Complete Word'.
There's no known trick 'in the wild' for getting around this, other than using CTP-6 of SQL Server 2008 (in favour of the RTM).
the reasons for removing backward compatability (and a lot more discussion besides) are provided at the relevant feedback in microsoft connect.
edit: sorry i don't know where this ctp is available, if at all
56
Has anyone tried either patching SSMS not to check the version (perhaps try looking at the binary differences between CTP 6 and RTM?), or patching SS 2005 to pretend to be 2008?
Unclean, I know, but I don't see any other way.
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
