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
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!