Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I don't have any Intellisense in SQL Server 2008 R2 Express Management Studio - is this supposed to work?

I am connecting to a SQL Server 2008 R2 Express database on the same machine (no other databases here at home) and I have no Intellisense.

Just wondering if it's supposed to work or is Express crippled?

share|improve this question

migrated from May 27 '11 at 22:53

This question came from our site for professional and enthusiast programmers.

try this to fix the problem, has to do with SP1 for vs2010 if you have that setup FIX: The IntelliSense feature in SSMS 2008 R2 may stop working after you install Visual Studio 2010 SP1

share|improve this answer
Yep that was my problem - brand new install of Windows 7, Visual Studio 2010 SP1 etc. Thanks! – Matt Frear May 26 '11 at 20:12

Intellisense only works if you are connected to a database that is SQL2008 or higher. If you use management studio to connect to a sql2000 or sql2005 server, there will be no intellisense.

Also, there is an option to turn it on/off. In SQL Server Management Studio, click Tools -> Options. Expand "Text Editor" and click on "All Languages". Make suer "Auto list members and Parameter information" are both checked.

share|improve this answer
Yeah thanks, I knew it had to be >= 2008 but my question was specifically about Express – Matt Frear May 26 '11 at 20:11

It has Intellisense on my machine, but only on a few servers. I think you need to enable some permissions for it to work.

share|improve this answer

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.