If your Intellisense in SQL Server Management Studio just stopped working, chances are you have applied Visual Studio 2010 SP1. This is because there is a compatibility issue between Microsoft SQL Server 2008 R2 Management Studio (SSMS 2008 R2) and the Transact-SQL Language Service that is included in Visual Studio 2010 SP1.
The good news is there is a fix included in the latest Cumulative Update package for SQL Server 2008 R2 – http://support.microsoft.com/kb/2507770
All you need to do is download the pack, install it, and go back to saving your keystrokes.
Neo Fight! 