question

Raj More avatar image
Raj More asked

No Intellisense from SSMS to SQL2005

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?

sql-server-2008t-sqlssmsintellisense
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Ken Simmons avatar image
Ken Simmons answered

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

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tom Staab avatar image
Tom Staab answered

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."

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Dugi avatar image
Dugi answered

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

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.