CODEWITHSUNDEEP
sql-server-2008
onefootswill
onefootswill

Reputation: 4107

Sql Server 2008 R2 Management Studio - no Intellisense

Can anyone suggest why intellisense is not working.

I am using 2008 R2.

I've seen people here suggest writing the FROM clause first - of course.

I've done Query - Intellisense Enabled.

I've done Refresh Local Cache.

I even installed it all on a whole new hard drive, with fresh OS.

I am at my wits end. It was so good when it worked, so long ago.

Upvotes: 2

Views: 7015

Answers (4)

Matstar
Matstar

Reputation: 410

It also stopped for me when is was previously working fine. I resurrected it by refreshing intellisense local cache with ctl+shift+R or via SSMS menu items: Edit -> Intellisense -> Refresh Local Cache.

Upvotes: 0

jacob justin
jacob justin

Reputation: 116

I also had the same problem, I tried to reinstall SQL and install latest service pack 2 and install cumulative update but that did not solve the problem.

What solved the problem was reinstalling visual studio 2010 service pack 1

Upvotes: 0

Aaron Bertrand
Aaron Bertrand

Reputation: 280570

There are a variety of things that could be wrong.

  • you may be connected to a SQL Server 2005 or earlier instance, or SQL Azure
  • your script may be too large (Tools / Options / Text Editor / Transact-SQL / IntelliSense / Maximum Script Size)
  • you may be in SQLCMD mode
  • make sure Management Studio is patched to >= @@VERSION of server - service packs are important for client tools too
  • third party add-ins may be interfering
  • the VS issue @Shark pointed out

My suggestion? Start playing with SQL Server 2012 SSMS. Sure, it's just a release candidate at this point, but I have been using it as my primary management tool for over a year and it is as or more stable than 2008/2008 R2 tools. And IntelliSense has some good improvements as well.

Upvotes: 1

user596075
user596075

Reputation:

Did you just install the Visual Studio 2010 SP1 update? If so, it's a known issue with SSMS IntelliSense.

Here is the description of the issue.

Here is the solution to the issue.

Upvotes: 7

Related Questions