Many of you might remember the lame Intellisense support that was in SQL Server Management Studio around the beta 1 timeframe. I hoped it would get better but instead it got dropped. Well, after being in the hills camping for a week I got home and started going through all the e-mail that had accumulated. I saw an offer from Red-Gate Software. You can download a free copy of their SQL Prompt tool to provide intellisense inside query analyzer or SQL Server Management Studio. The link to the free download is
http://www.red-gate.com/products/SQL_Prompt/index.htm. It required some personal information but they say that it will not be shared so I gave it to them.