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.
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.
Thanks for the warning, Greg. That was close – I was planning to install that soon.
Gah! That explains where it disappeared..
Time to reapply CU6.
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)