SQL Server 2008 R2 intellisense not working

Question

Just started a new job and everything was already installed on my machine. It's not exactly a friendly bunch. (early days)

I have SQL Server 2008 R2 and I see I have Visual Studio 2010 SP1.

I don't have any intellisense in SQL Server Management Studio.

Googled and found hundreds of hits!!!

Ultimately I have found this link:

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2507770&kbln=en-us#step1

The problem is I have so many hotfixes to choose from and I don't know which one Do you know?

thanks a lot

Answer 1

First of all - intellisense in SQL Server Management Studio 2008 and newer only works against databases that are also 2008 or newer - it will not work against a 2005 database.

Next - have you made sure intellisense is enabled in SSMS ?

Then - if it is enabled - sometimes it helps to refresh the local cache:

Answer 2

Late answer but can be useful to other readers:

If you installed Visual Studio 2010 SP1 and you’re using SQL Server 2008 R2, it is likely that your IntelliSense may stop working. There is a fix for this and it was released in SQL Server 2008 R2 SP1.

For more information please read this KB article: https://support.microsoft.com/en-us/kb/2531482

According this article http://www.sqlshack.com/using-and-troubleshooting-sql-server-intellisense-sql-server-2012-higher/, here are some of the common reasons why IntelliSense isn’t working:

1. Firstly check if IntelliSense is enabled as explained earlier in the article. Also ensure that the Statement Completions settings are correct.

2. Ensure that there is no syntax error anywhere on the page before your cursor, resolving the code error should re-activate IntelliSense.

3. IntelliSense does not work inside comments, uncomment the section to be able to get the suggestions.

4. IntelliSense does not work inside a quotes. Be sure to place your cursor outside of any quotes.

5. Ensure that you are connected to a SQL Server Instance or a database project.

6. IntelliSense is only supported on SQL Server 2008 and higher.

7. IntelliSense does not work for encrypted objects.

8. Not all syntax is supported.

9. Are you running in SQLCMD mode? Unfortunately IntelliSense is not supported in command mode. Return to regular mode to get IntelliSense.

10. IntelliSense is currently not supported for SQL Azure