Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This problem is really proving to be a tricky one (and quite annoying).

In SQL Server Management Studio 2008, up until a few days ago my IntelliSense was working great. Then all of a sudden it stopped. The icon as it as enabled on the toolbar menu, and under Tools -> Options -> Text Editor -> T-SQL -> IntelliSense it says it is enabled there.

I have tried refeshing the IntelliSense cache with Ctrl-Shft-R but that doesn't work either.

Any ideas what happened to my IntelliSense and what I need to do to get it back?

share|improve this question
did you update your visual studio to sp1? –  Ezi Sep 25 '11 at 19:53
I added it as a answer... –  Ezi Sep 25 '11 at 19:56
SQL prompt can also be an alternative red-gate.com/products/sql-development/sql-prompt –  xameeramir Jun 13 '14 at 10:25

2 Answers 2

up vote 4 down vote accepted

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

share|improve this answer

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, hen 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

share|improve this answer
Thanks. Intellisense was buggy, ctrl+shift+r fixed my problems –  TombMedia Feb 3 at 20:14
I created an account here to upvote your answer. it was ctrl-shift-R, and it was driving me crazy! –  CindyH Mar 27 at 16:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.