Friday, 15 April 2016

How To Enable Intellisense In SQL Server Management Studio 2008 R2

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.

This section is under Transact-SQL. The checkbox for "Enable IntelliSense" should be ticked.

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

Related Posts Plugin for WordPress, Blogger...