After installing Visual Studio 2010 Service Pack 1, I noticed that intellisense had stopped working in SQL Server Management Studio 2008 R2. The issue was noted in Scott Guthrie’s blog, a few weeks ago. I discovered today that a hotfix is available from Microsoft as a part of SQL Server 2008 R2 cumulative update 7. I’ve installed update 7, and verified that intellisense works again.