Actually what happens when you connect to sql server 2008 using sql server management studio is, it queries for the current database schema and saves it somewhere. And It uses this schema information for showing the intellisense when the user is writing queries. But when we create/update the sql objects (sprocs, tables, views, ...) these won't be updated and the intellisense is pulled from old schema. That's why we don't notice the schema changes in intellisense unless we explicitly refresh the cache. In order to get new chema changes we must clear the intellisense cache.
To clear the intellisense cache we need to click Edit -> Intellisense -> RefreshLocalCache in sql server 2008 management studio as shown in below screen.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinxXt6K-05eP6kNIMKyiLH3DRcRned4_Q2IF8PCKZGNgQxacJWWO1KEmyBmkXXd_jfwey55zkTPiIXiygsOFgvbuEJ70u3Uht-BcUJioN_VUYRalr8vtAKn2WSsKlzzB629ZYwRmF7ZjSF/s400/ClrearSqlIntelliSenseCache.png)
7 comments:
Nice tip. that helps.
Thanx NBow i think i don't have to use RedGate for Refreshing Cache
Nice tip!
Thanks, that's great :-)
This thing has annoyed me for ages. Finally did a google search and got to this page. Thanks :-)
AWESOME! Driving me Nuts!
very useful article, thanks a lot :)
Post a Comment