MS SQL 2008 R2 IntelliSense

For a further investigation, please try these steps as below: 

1. Enable IntelliSense: 

   1. For all query windows, please go to Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense, and select Enable IntelliSense.
   2. For each opening query window, please go to Query >> Intellisense  Enabled.  
2. Refresh IntelliSense local cache: please go to >> Edit >> IntelliSense >>Refresh Local Cache or use the CTRL+Shift+R keyboard shortcut to refresh.
3. Enable statement completion: please go to Tools >> Options >> Text Editor >> Transact-SQL >> General, and check on Auto list members and Parameter information boxes.
4. Reboot SQL Server Management Studio.

출처 : http://social.msdn.microsoft.com/Forums/en/sqltools/thread/36e3d0db-3150-434a-885d-97810fe199c5