up vote 2 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

migrated from stackoverflow.com May 27 '11 at 22:53

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

3 Answers

up vote 2 down vote

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

link|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
feedback
up vote 1 down vote

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.

link|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
feedback
up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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