How To Troubleshoot IntelliSense in SSMS

The IntelliSense option in SQL Server Management Studio (SSMS) is a boon for database programmers as it makes the programming faster by reducing typing, giving quick access to syntax, etc. However, for some reason, if IntelliSense stops working in SSMS, how to troubleshoot and make it work again?

Here are a few of the basic steps I have followed to troubleshoot IntelliSense and fix the problem.

Enable IntelliSense in settings

The first step of troubleshooting IntelliSense is to check and make sure IntelliSense is enabled in the settings.

  1. Launch SSMS and go to menu Tools >> Options.
  2. In the Options window, expand TextEditor >> Transact-SQL >> IntelliSense.
  3. Make sure Enable IntelliSense is selected.

NOTE: Enabling IntelliSense in settings window, enables it by default for all the Query Windows.

Troubleshoot IntelliSense - Enable In Settings

Enable IntelliSense for the current query window

Now, check if IntelliSense is enabled for the Query Window which you are currently using.

  1. Open a query window.
  2. From the menu go to Query.
  3. In the Query drop down, make sure IntelliSense Enabled is selected.

NOTE: This action enables or disables the IntelliSense option only for the current Query Window.

Enable IntelliSense for the query window

Enable statement completion

  1. Go to menu Tools >> Options.
  2. In the Options window, expand Text Editor >> Transact-SQL >> General.
  3. Under the Statement completion section, select both the options Auto list members and Parameter information.
Enable statement completion

Refresh IntelliSense

If IntelliSense is still not working, try refreshing the cache.

  1. Open a query window.
  2. From the menu go to Edit >> IntelliSense >> select Refresh Local Cache.

NOTE: You can also use the shortcut keys Ctrl+Shift+R to refresh the local IntelliSense cache.

Refresh IntelliSense Cache

Related Articles

Reference


Leave your thoughts...

This site uses Akismet to reduce spam. Learn how your comment data is processed.