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?
asked
No Intellisense from SSMS to SQL2005
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.
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=341872
Unfortunately, you cannot.
http://technet.microsoft.com/en-us/library/ms173434.aspx
"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."
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.
No possible, just if you install third part tool for SQL intellisense!
Intellisense is not available for SQL Server 2005 even if you connect from SQL Server 2008! - that's it
