12

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?

enter image description here

thanks a lot

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user9969
  • 15,632
  • 39
  • 107
  • 175
  • 1
    Intellisense is not provided by SQL Server. It's provided by SQL Server Management Studio, which retrieves metadata about the database and offers suggestions for you. Do you have permission to read the database structure? – ta.speot.is Sep 08 '11 at 06:11
  • 1
    What version of the database are you connecting to? If you have SQL Server Management Studio 2008 R2, but you're connecting to a SQL Server 2005 database - there's no intellisense support there! – marc_s Sep 08 '11 at 06:42

7 Answers7

20

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 ?

enter image description here

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

enter image description here

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
  • 2
    Marc,Done all that still not working.I am using all sql server 2008 connecting to a sql server 2008 database.still not working – user9969 Sep 08 '11 at 08:01
  • 2
    Its a bug that occurs when you install SP1 of Visual Studio 2010. Its not user error. – TizzyFoe Feb 25 '13 at 19:31
  • For SQL Server 2008, check this link https://blog.sqlauthority.com/2009/03/31/sql-server-2008-intellisense-does-not-work-enable-intellisense/ – Abdul May 15 '17 at 09:53
4

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

Jigoro Kano
  • 96
  • 3
2

I just had the same issue and realized that is nothing about VS 2010 or whatever app.

All you have to do to enable IntelliSense on SQL 2008 is:

1) Run Windows Update and install 2 updates about SQL Server 2008 (SP1 and SP3); Link - http://www.catalog.update.microsoft.com/Search.aspx?q=SQL%20Server

2) Restart and make sure Intellisense is enable on SQL Server: Tools>Options>Text Editor>Transact-SQL>IntelliSense

3) Refresh Local Cache by pressing Ctrl + Shift + R

4) Done.

kumar
  • 13
  • 4
Bronks
  • 67
  • 1
  • 6
2

Also if you have Query | SQLCMD turned On it will stop IntelliSense from working, even though you have it set up in all the places mentioned above and you are on the latest patch.

KAHartle
  • 125
  • 1
  • 6
1

To answer your question directly, one of the answers on this post, Why is SQL Server 2008 Management Studio Intellisense not working?, suggests that the second from the bottom would be the one you want:

SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x64

However, that is just the hotfix that this was released in, there are more current cumulative updates. See the list here: http://support.microsoft.com/kb/981356

Community
  • 1
  • 1
wilsjd
  • 2,178
  • 2
  • 23
  • 37
1

Though you're having SQL Server 2008 R2 IDE but if you're connected with SQL Server 2005, intellisense won't work.

Please check out this link, it might help you to solve your problem.

Nilesh Thakkar
  • 2,877
  • 1
  • 24
  • 43
-1

Please re-install sql or Search on google Download "SQLServer2008R2-KB2507770-x86.exe" and Run 100% Work For sql sever R2 2008

SAURABH TRIPATHI
  • 11
  • 1