>SQL Server: How to Refresh Intellisense Cache


Intellisense in SQL Server 2008 is a time saving feature. But sometime writing queries it start underlining some objects names or some columns names which are already added in database and these are correct but intellisense mark them as a MISTAKE. In long queries it creates confusion. I have seen my fellow DBAs, turning off the feature to avoid confusion and mental stress;).
Also, sometime intellisense is not helping enough for auto-complete feature. 
Simple solution for this problem is to refresh local cache by using  Ctrl + Shift + R. So it should start marking only real mistakes. You can also refresh local cache from FILE — >IntelliSense — > Refresh Local Cache

Posted on February 24, 2011, in Sql Server 2008, SSMS. Bookmark the permalink. 2 Comments.

  1. Great help! Thanks.Note however, it's the Edit Menu, not the File Menu, i.e., :Edit >> Intellisense >> Refresh Local Cache

  2. Thanks Erobishaw…. Correction made

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: