Cleveland DBA

SQL Server administration in Cleveland, OH

IntelliSense tip

The IntelliSense feature of SSMS in SQL 2008 is a handy feature, overall I really like it.  There was one thing that was bugging me though: If I made any schema changes while SSMS was open, Intellisense didn’t seem to know about it.  It would mark any references to those changes as invalid.  The sql would still run, mind you, it was just annoying seeing red squiggly lines everywhere.

Well it seems IntelliSense has its own little cache in SSMS and you need to refresh it with the current metadata information.  This can be done by going to Edit -> Intellisense -> Refresh Local Cache or by hitting CTRL-Shift-R.

Just thought I’d share that here in case anyone else was running into the same problem.

Advertisements

May 31, 2011 - Posted by | Features | ,

1 Comment »

  1. THANK YOU for telling me how to fix that. Happens to me all the time!!

    Erin

    Comment by erinstellato | June 20, 2011 | Reply


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: