Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
IntelliSense does not see new objects in SQL Server Management Studio
The version of SQL Server Management Studio that ships with SQL Server2008 comes with IntelliSense enabled, I still think IntelliSense is sometimes more in my way than it is useful but I won't bore you with that.
What will eventually happen is that if you create new tables and stored procedures IntelliSense will not know about those, when this happens you have to refresh the local IntelliSense cache for it to see the new objects.
There are two ways to do it, one way is to click on Edit-->IntelliSense-->Refresh Local Cache (see image below)
You can also just hit the CTRL + SHIFT + R shortcut
Contributed by: --SQLDenis 14:30, 5 June 2010 (GMT)
Part of SQL Server Programming Hacks