Thursday, November 1, 2012

SQL Server 2008 R2 IntelliSense not working

I had the same issue, that intellisense did not work on SQL Server 2008 R2 There might be different reasons.
  • One of the reason for this behavior can be a database switched offline. When  switched all databases online, intellisense worked (after i refreshed the local cache if it is caused by this reason).
  • Another check you should check if your IntelliSense is enabled in the Query Drop down menu it'll be visible if you open a query window confirm it is enabled.
  • You should refresh you local cache from Edit menu then IntelliSense and then click on Refresh Local Cache or shortcut key is Ctrl + Shift + R
if still its not working

I hope this'll fix your problem thanks for reading...

No comments:

Post a Comment