Intellisense in SQL Server 2008 is a time saving feature. But sometime writing queries it start underlining some objects names or some columns names which are already added in database and these are correct but intellisense mark them as a MISTAKE. In long queries it creates confusion. I have seen my fellow DBAs, turning off the feature to avoid confusion and mental stress;).
Also, sometime intellisense is not helping enough for auto-complete feature.
Also, sometime intellisense is not helping enough for auto-complete feature.
Simple solution for this problem is to refresh local cache by using Ctrl + Shift + R. So it should start marking only real mistakes. You can also refresh local cache from Edit--- >IntelliSense --- > Refresh Local Cache
Great help! Thanks.
ReplyDeleteNote however, it's the Edit Menu, not the File Menu, i.e., :Edit >> Intellisense >> Refresh Local Cache
Thanks Erobishaw.... Correction made
ReplyDeleteThanks, solved my problem.
ReplyDeleteThanks!
ReplyDelete