Free Intellisense for SQL Server!
I read this morning that Red Gate Software has released a *free* program that adds Intellisense to your standard SQL editors (Query Analyzer, Enterprise Manager, Management Studio and VS). I tried it out, and had it up and running in less than five minutes. Since I write a lot of queries everyday, and often find myself retyping the same things over and over, this is sure to be a huge timesaver. You can download the installer from here:
http://www.red-gate.com/products/SQL_Prompt/index.htm
Thanks to Dan Wahlin for writing this up and posting it to DotNetKicks.com, where I found it.