Sql-server – Intellisense in SSMS 2012 not working for 2008 server

intellisensesql-server-2008sql-server-2012ssms

I did most of the solutions provided here.

I know about

  • enabling IntelliSense
  • clearing the cache
  • connecting to a server >= SQL Server 2008
  • using the latest SQL Server Service Pack

and it works locally with the SQL Server 2012 engine.

But it still does not work when connecting to a SQL Server 2008 SP1 engine from my SSMS 2012. If I do

SELECT SERVERPROPERTY('ProductVersion')

I get 10.0.2573.0 as result. So the server is 2008 SP1.

Edit

After a few days it started working. I don't know why.

Best Answer

Try patching your server. I attempted to recreate your issue with SSMS 2012 (11.0.3000) by connecting to four servers: one SQL Server 2008 (10.0.1600) and three SQL Server 2008 SP 1 (10.0.2531). As you can see the only difference between the four servers is one server does not have Service Pack 1 installed. On all of the servers with service pack 1 installed intellisence worked without issue. However, intellisence did not work on the server without service pack 1 installed.

You can download the service pack here. http://www.microsoft.com/en-us/download/details.aspx?id=20302

Related Question