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