Archive for February, 2010

Sql 2008 Intellisense

February 2nd, 2010 2 comments

I’ve been using Sql 2008 fairly regularly lately with a couple of projects.  I realize there are far bigger features with this release, but Intellisense is great!  I love my Intellisense with Visual Studio, and now having it with Sql Server is nice.

I’m in the process of creating a new database, and therefore adding several tables and populating them with data.  It was frustrating to add a table, but it not appear with Intellisense when writing an insert statement.  Those red squiggly lines always jump out, and I think I’ve misspelled the table name yet the statement is correct.

The fix is simple, all you have to do is update the Local Cache one of 2 ways:

  • Edit -> Intellisense -> Refresh Local Cache
  • Control-Shift-R

Personally I am a fan of the second method, the more I can do without my mouse the faster I can go.  But either works fine.  Now, back to my database!