IntelliSense not working but it is enabled

There are number of possibilities where IntelliSense not working:

There are cases where the local cache used by IntelliSense becomes stale. Refreshing the cache is easy but not necessarily obvious.

There are two ways to refresh the cache:

1. Hit Ctrl+Shift+R
2. Go to Edit -> IntelliSense -> Refresh Local Cache

If IntelliSense is still not working, then make sure you have IntelliSense enabled. To check this from the T-SQL Query editor window of the current database:

1. Go to Tools -> Options -> Text Editor -> Transact-SQL -> General -> IntelliSense
2. Go to Query -> IntelliSense should be selected

3. Also verify that the T-SQL Editor does not launch in SQLCMD Mode. To check:

   • Go to Tools -> Options -> Query Execution -> SQL Server -> General
   • Make sure "By default, open new queries in SQLCMD mode" is unchecked.
   • or Go to Query -> SQLCMD Mode should not be selected

Read More

I had this problem, so I followed Ritesh D's advice and went to Tools -> Options -> Text Editor -> Transact-SQL -> General. I checked IntelliSense, and found it was enabled already.

However, I found that "Auto list members" and "Parameter information" were unchecked. So I checked them. This solved my problem.

These two features are what I think of as "intellisense", and Microsoft does not disagree:

IntelliSense is the general term for a number of features: List Members, Parameter Info, Quick Info, and Complete Word. These features help you to learn more about the code you are using, keep track of the parameters you are typing, and add calls to properties and methods with only a few keystrokes.

If you recently upgraded your VisualStudio then see this link for a fix:

The IntelliSense feature in SSMS 2008 R2 may stop working after you install Visual Studio 2010 SP1

Or you could download the fix directly from here:

How to obtain the latest service pack for SQL Server 2008 R2