Tony Rogerson's ramblings on SQL Server

I've been using it for a couple of days now in SQL Management Studio and it seems to work really well! It's not getting in the way and adds value most of the time.

On my super duper workstation its very quick, remarkedly actually, not sure on a slower box.

Anyway, its worth a try.

You can download it from here : http://www.red-gate.com/products/SQL_Prompt/index.htm

From Red-Gate's website:

SQL Prompt provides Intellisense^® style auto-completion for Microsoft SQL Server editors. It will tell you the exact formatting you should use for your SQL commands, while you are writing them and will therefore help you write fast, perfectly formatted SQL statements. SQL Prompt improves the productivity of all SQL script creation. SQL Prompt can be downloaded free until 1st September 2006 and we are providing forum support on the SQL Prompt support forum.

SQL Prompt simply sits behind the scenes and provides unobtrusive help when you press Ctrl-Space or when you type "." after a table/view/alias name.

Features include :

• Table/View name completion
• Column name completion
• Stored procedure name completion
• USE completion
• JOIN/JOIN ON completion
• Auto-uppercasing of keywords
• Auto-popup after keywords

SQL Prompt works with Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2000 Enterprise Manager, UltraEdit32. Please note that Intellisense is a registered trademark of the Microsoft Corporation, we have a dedicated web page describing Red Gate's relationship with Microsoft.