Wednesday, February 2, 2011

Enabling IntelliSense and Refreshing IntelliSense Data in SSMS 2008

There may be times when IntelliSense in SQL Server Management Studio 2008 is not working or does not display the latest schema changes. To resolve these issues you can follow the below solution.

One of the new features of SSMS 2008 is IntelliSense. IntelliSense is a feature which reads internal metadata and provides a list of available objects and properties while you are writing T-SQL. Sometimes IntelliSense does not work when using SQL Server Management Studio 2008. To fix this you can follow the below steps.

Step 1: Go to Tools > Options > Text Editor > Transact-SQL > IntelliSense and make sure the Enable IntelliSense checkbox is checked

Step 2: To verify that it is enabled, go to the Query menu and check that IntelliSense is enabled as shown below.

Step 3: If you are unable to see the IntelliSense for the latest schema changes then from a query window, go to Edit -> IntelliSense -> Refresh Local Cache. You can also use the Ctrl + Shift + R shortcut to refresh the cache.

1 comment:

  1. Nice Article !
    This is my pleasure to read your article.
    Really this will help to people of SQL Server Community.

    I have also prepared one article about, How to refresh SQL Server Management Studio IntelliSence Local Cache.
    You can also visit my article, your comments and reviews are most welcome.