SQL Prompt is a great program put out by Red Gate.
They just released a deal where they are giving it away for free until September 1st 2006 (That’s when they will release a new version of the product.)
I downloaded it and tried it out, and it works great – very handy to have when you are dealing with tables with lots of fields, etc. It works with Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2000 Enterprise Manager, UltraEdit32.
I personally tried it out with Microsoft Query Analyzer.
Here’s the link to the download page: SQL Prompt