Ran into this tonight. The other day I updated to Visual Studio 2010 SP1, and my IntelliSense in SQL Server Management Studio (SSMS) 2008 R2 stopped working.
I updated by SQL 2008 R2 install to CU6 and the IntelliSense started working again.
SQL 2008 R2 IntelliSense May Stop Working After Updating to VS2010 SP1
Steve Novoselac's Blog 
2 replies on “SQL 2008 R2 IntelliSense May Stop Working After Updating to VS2010 SP1”
Steve,
You should plug the connect item created for this and get some visibility to that.
https://connect.microsoft.com/SQLServer/feedback/details/650569/ssms-2008-r2-is-losing-intellisense-after-installing-visual-studio-2010-sp1
LikeLike
But it is only partly working or can you see column names and error highlighting?
I had Win7 Ent without SP1 and had the same problem, but it only works partly after CU6.
I have tried all things … like uninstall VS2010 SP1 or installing Win7 SP1 …
But in the end it didn’t work, so I reinstalled the whole system 😦 and I will never install a new update without testing the whole system with backup.
Greets
Patrick_Fiedler
LikeLike