The intellisense is a feature in SQL Server Management Studio 2008 R2 (SSMS) that assists T-SQL developers to easily know the underlying tables or fields of a database when typing codes from within the query editor. Functions and variables may also popup as soon as you begin typing one or the first two letters of the keyword.
Some may find it weird that even after having SSMS configured to enable this feature, it just won't work. My best guess is that their SSMS isn't upgraded to SP3 yet. To upgrade the SSMS 2008 R2 to SP3, please visit this download link and choose the appropriate platform for you.
Once installed, restart your SSMS and check for the following settings. Go to TOOLS menu and select OPTIONS.
By this time, the intellisense should kick-in. If not, please check if "IntelliSense Enabled" is clicked under the Query menu. The icon is sunken if it is enabled.
Lastly, try to refresh the IntelliSense local cache by pressing Ctrl+Shrft+R while in the query editor. I hope that you were able to get your IntelliSense working.
Until next time!
No comments:
Post a Comment