Why Intellisense doesn't work in SQL Server Management Studio 2008 R2?

Question

I have SQL Server Management Studio 2008 R2.

I have tried these:

1. Tools->Options->Query Execution->SQL Server->General, make sure “By default, open new queries in SQLCMD mode” is unchecked

2. Go to Tools >> Options >> Text Editor >> Transact-SQL >> General >> IntelliSense Select Auto List Members and Check Parameter Information.

3. Restarted, repaired Visual Studio 2010

4. Installed VS 2010 SP1

5. Query/Intellisense Enabled selected

But still it doesn't work.

Any clue?

Answer 1

Apparently when you install VS2010 SP1 it breaks intelliSense of SQL Server 2008 R2. You will need to install either CU or SP1 for SQL Server 2008 R2 mentioned in this Support KB from MSFT.