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.
SSMS Tips and Tricks Free eBook
Want to become a wizard on using SSMS? My free eBook covers so many tips and tricks, including this one. You’ll find it, and many other free resources from us, here: https://sqldownunder.com/freestuff/
2011-03-23