Ok, this is pretty cool. I saw this on Scott's blog and had to try it since I am doing so much SQL Sever work lately. RedGate released a free program that enables IntelliSense when working with SQL Queries. What's cool is it works in everything from SQL Server Management Studio, Visual Studio 2005/2003 and even Enterprise Manager. Once you get it installed activate it by pressing Ctrl+Space. So far from what I have seen it works great.
SQLPrompt
Read the complete post at http://www.dotnettipoftheday.com/blog.aspx?id=282