SQLPrompt, also known as SQL Intellisense, is a great add-on to SQL Workbench and Query Analyser available from red-gate software. SQLPrompt is described on their website as
* Code completion for fast, accurate script building
* Discoverability in SQL Server query creation
* Keyword formatting, code snippet integration and other extended features
* FREE until release of version 3 (December 2006)
* No time-bombs, no restrictions
Tomorrow is December 1st but perhaps they won't release version 3 until the end of the month. Check it out.. you've gotta fill out a form to download the software but it's worth it:
SQLPrompt from red-gate software.