Is there any trick that allows to use Management Studio's (ver. 2008) IntelliSense feature with earlier versions of SQL Server? 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.]
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.