patternsqlMinor
Is there any trick that allows to use Management Studio's (ver. 2008) IntelliSense feature with earlier versions of SQL Server?
Viewed 0 times
allowstrickver2008serverwithsqlanyversionsearlier
Problem
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.]
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.]
Solution
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.
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.
Context
StackExchange Database Administrators Q#1141, answer score: 7
Revisions (0)
No revisions yet.