Paul Litwin's Blog

Red Gate software is giving away the current version of their their SQL Prompt tool to everyone. This is until October 3rd when they will ship the new version of this great tool. (By the way, there are no time bombs or restrictions on the download. Obviously, they are hoping that this will get people to know their products and you will want to buy the new version 3 of SQL Prompt when it ships but you are under no obligation.) SQL Prompt adds IntelliSense for building SQL statements in SQL Server 2000's Query Analyzer, SQL Server 2005's Query tool within SQL Server Management Studio, and Visual Studio 2003 and 2005's sever explorer (when used to created stored procedures). It probably works elsewhere as well for all I know...In fact the full list of products can be found on the Options tab of the SQL Prompt Options dialog. Reading from there, the current (free) version supports Query Analyzer, Enterprise Manager, SQL Server Management Studio, VS 2003, VS 2005, UltraEdit, and EditPlus 2.

Download it from http://www.red-gate.com/products/SQL_Prompt/index.htm

Very useful little utility. Highly recommended. These guys sell the very cool SQL Compare tool as well which we are evaluating and plan to purchase soon. Great utility for comparing the schema of two SQL Servers and scripting the changes.

Paul