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
- There are some hot-fixes available for this problem like in this link http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2507770&kbln=en-us
- but personally I don't recommend those they can harm your system as support team say I recommend upgrade your SQL Server R2 to Service Pack 1 see this link http://www.microsoft.com/en-us/download/details.aspx?id=26727
No comments:
Post a Comment