Red-Gate has just announced that they will be offering SQL Prompt 2.0 for FREE!!
SQL Prompt provides Intellisense-style code auto-completion for Microsoft SQL Server editors,
for fast and accurate script building. SQL Prompt works with Query Analyzer, Management Studio,
Visual Studio and Enterprise Manager.
SQLDiva