SQL: SQLPrompt Free Today, Perhaps Not Tomorrow
* 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.