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

Question

I have SQL Server Management Studio 2008 R2.

I tried these:

• Tools-> Options-> Query Execution-> SQL Server-> General, make sure that "By default, open new queries in SQLCMD mode" is not checked

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

• Restart, fix Visual Studio 2010

• Installed VS 2010 SP1

• Selected query selected / Intellisense

But still it doesn’t work.

Any clue?

Answer 1

Apparently, when installing VS2010 SP1, it crashes intelliSense SQL Server 2008 R2. You will need to install CU or SP1 for SQL Server 2008 R2, mentioned in this Support KB from MSFT.

Answer 2

Visual Studio 2010 SP1 seems to have broken something:

https://connect.microsoft.com/SQLServer/feedback/details/650569/ssms-2008-r2-is-losing-intellisense-after-installing-visual-studio-2010-sp1

Answer 3

It was today. After the thread that I found elsewhere, the solution was to disable all offline databases. Service restart and boom! started to work.

Answer 4

This is a pretty old question, but I ran into the same problem, and the fix for it was to repair the sql server 2008. The trick was that I had to add / remove programs before doing the repair remove "Microsoft SQL Server Compact <Ver> <SP1 / 2 <Lang> "before repair, because its installation file name is different in the Sql Server installer than the VS installer.

Answer 5

Stand-alone databases cause Intellisense to stop working in RTM 2016 and Sql Server 2016 RTM, possibly earlier versions. Test this by opening a new query window and checking the operation of Intellisense. Then he took the database offline and tried Intellisense ... it stopped working. They brought the database back to the Internet, and Intellisense comes back to life and starts working again.