March 10, 2011

SQL Server: SSMS 2008 Intellisense Stops Working after Installing VS 2010 SP1




After installing VS 2010 SP1, Intellisense stopped working in SQL Server Management Studio SSMS 2008 and R2 databases. After searching on the net, I found that this issue is being discussed on this thread and a MS support guy Weilin Qiao has given the following suggestion:

  1. Go to Tools > Options > Text Editor > Transact-SQL > IntelliSense, and select Enable IntelliSense.

  2. For each opening query window, please go to Query >> Intellisense Enabled.

  3. To refresh IntelliSense local cache, go to Edit > IntelliSense > Refresh Local Cache or use the CTRL+Shift+R keyboard shortcut to refresh.

  4. Enable statement completion: Go to Tools > Options > Text Editor > Transact-SQL > General, and check on Auto list members and Parameter information boxes.

  5. Reboot SQL Server Management Studio.

I have tried the suggestions without much success and probably I will uninstall Sp1 and reinstall it again. I will update this post once I am able to figure this out! If you have a solution that works, please share it with the readers.

Update and a Workaround: Anonymous pointed me to a thread on MSConnect where a workaround shared by Richard Glidden is to install SQL Server 2008 R2 Cumulative Update 6 (http://support.microsoft.com/kb/2489376)


Did you like this post?
kick it on DotNetKicks.com
subscribe via rss subscribe via e-mail
print this post follow me on twitter


About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

 
  Feedback:

comments

3 Responses to "SQL Server: SSMS 2008 Intellisense Stops Working after Installing VS 2010 SP1"
  1. Anonymous said...
    March 10, 2011 at 10:55 PM

    A workaround has been described in this thread.
    https://connect.microsoft.com/SQLServer/feedback/details/650569/ssms-2008-r2-is-losing-intellisense-after-installing-visual-studio-2010-sp1#

  2. Suprotim Agarwal said...
    March 10, 2011 at 11:19 PM

    Thank you so much Anonymous. I have updated the original post.

  3. un empathique said...
    March 2, 2012 at 7:55 AM

    The microsoft bugfix has fixed the problem for me.
    Thank you !

 

Copyright © 2009-2014 All Rights Reserved for SQLServerCurry.com by Suprotim Agarwal | Terms and Conditions