4

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.]

Community
  • 1
Marek Grzenkowicz
  • 1,495
  • 2
  • 18
  • 27

3 Answers3

7

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.

jcolebrand
  • 6,376
  • 4
  • 43
  • 67
6

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.

mrdenny
  • 27,106
  • 2
  • 44
  • 81
4

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.

Marian
  • 15,741
  • 2
  • 62
  • 75