THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Warning: Don't apply VS2010 SP1 (yet) if Intellisense in SSMS matters to you

This one is a bit annoying. When you apply SP1 for Visual Studio 2010 (VS2010), one of the side effects seems to be that you lose Intellisense in SQL Server Management Studio 2008 R2 (SSMS).

If Intellisense matters to you, you might want to wait for a cumulative update to fix it.

Details here: https://connect.microsoft.com/SQLServer/feedback/details/650569/ssms-2008-r2-is-losing-intellisense-after-installing-visual-studio-2010-sp1

Published Wednesday, March 23, 2011 2:33 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

AaronBertrand said:

Just FYI, you get *some* of the functionality back if you (re-)apply CU6 after applying the VS service pack.

Using a 3rd party tool (like RedGate's SQL Prompt, or a free one like DevArt SQLComplete Express) seems to be a viable workaround.

March 22, 2011 10:59 PM
 

David Wimbush said:

Thanks for the warning, Greg. That was close - I was planning to install that soon.

March 23, 2011 10:08 AM
 

Rjohal said:

Gah! That explains where it disappeared..

Time to reapply CU6.

March 23, 2011 10:25 AM
 

Theah said:

THANK YOU!

Intellisense is the #1 reason I switched from 2005 to 2008. They'll have to pry Intellisense from my cold, dead hands before I'll update anything to take it away. (yeah, I know it probably wasn't intentional)

March 24, 2011 4:50 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement