I just thought I'd let everyone know about a really awesome utility for Sql Server. The product, known as Sql Prompt from Red-Gate Software puts Visual Studio like intellisense into Query Analyzer or the query windows in Sql Management Studio. Best of all, it's free until September 1st !
This little utility is absolutely great. I no longer have to empty all the blood out of my keyboard (from having worn my fingers down to the nub) after spending a day coding stored procedures and triggers !
I have noticed it can cause some small performance problems occasionally when it builds the list of keywords, and two of my colleagues have had it crash on them a couple of times (although it left their Sql Server windows intact and they didn't loose any data). For the most part though, it's a life saver, and we highly recommend it.