I have SQL Server Management Studio 2008 R2.
I have tried these:
Tools->Options->Query Execution->SQL Server->General, make sure “By default, open new queries in SQLCMD mode” is unchecked
Go to Tools >> Options >> Text Editor >> Transact-SQL >> General >> IntelliSense Select Auto List Members and Check Parameter Information.
Restarted, repaired Visual Studio 2010
Installed VS 2010 SP1
Query/Intellisense Enabled selected
But still it doesn't work.