I get Intellisense from SSMS 2008 to SQL2008, but none from SSMS 2008 to SQL 2005.
How do I make Intellisense available when connecting to SQL 2005?
Answer by Tom Staab ·
Unfortunately, you cannot.
"Intellisense is only available when the Database Engine Query Editor is connected to an instance of the SQL Server 2008 Database Engine. IntelliSense is not available when the Query Editor is connected to earlier versions of the Database Engine."
Answer by Ken Simmons ·
Intellisense does not work with older versions. It did prior to SQL 2008 RTM, but there were some issues. Here is a connect article on it.
Answer by Matt Whitfield ·
You have three choices:
1) Buy Red Gate SQL Prompt. £125. That's a good code completion provider, but doesn't provide intellisense features.
2) Buy another plug-in to SSMS (which are all pretty dire, to be honest), or buy Apex SQL Edit which is a new environment - $399.
3) Wait until I release my editor (January) - that will provide code completion and intellisense on 2000+, and will be free for personal use.