Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
SQL Server Management Studio 2012 is the only environment that supports SQL Server Intellisense. Have you tried a server side trace to see if the Intellisense session is getting errors? –  Max Vernon Sep 4 '13 at 14:24
2  
@MaxVernon Intellisense has been in SSMS since 2008. technet.microsoft.com/en-us/library/bb934481(v=sql.100).aspx –  Shawn Melton Sep 5 '13 at 13:24
    
Hmmm... Thanks for pointing that out Shawn. Clearly I'm wrong about it not being supported in 2008. Still, a server side trace should allow the OP to see what is happening/not happening with Intellisense, right? –  Max Vernon Sep 5 '13 at 13:53

1 Answer 1

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.