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.

Latest version of Management Studio (i.e. the one that ships with SQL Server 2008) finally has a Transact-SQL IntelliSense feature. However, out-of-the-box it only works with SQL Server 2008 instances.

Is there some workaround for this?

[I asked this question a while ago at StackOverflow and unfortunately nobody knew such a trick. Maybe I will have more luck with this problem here.]

share|improve this question
add comment

3 Answers 3

up vote 6 down vote accepted

Aside from using a third party tool, no. I run into this problem a lot too. The deal is the SqlServer2005 doesn't support the meta data to do that.

However, I can suggest (cos I used it for a bit and loved it) RedGates SqlPrompt product to do this. It's incredibly handy. However, it does cost money, so there's a tradeoff.

If someone DOES have a workaround for this, I would love to hear of it.

share|improve this answer
add comment

No, there is no workaround to make it work. It looks at the version of the remote server which can't be faked. SQL Prompt would be your best bet, that or upgrading to SQL Server 2008 or higher.

share|improve this answer
add comment

I've been using from time to time the SQL Complete. It has a free version. It's a newcomer, from what I know. I've also liked the SQLPrompt too, in the past, but it's not free. So give them a try.

share|improve this answer
add comment

Your Answer

 
discard

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.