Red Gate has released SQL Prompt 2.0, a pretty cool auto-complete and Intellisense for SQL Server Management Studio and Query Analyzer. The best part: t is FREE! Download it here.
When you load it up and connect to a database, it will ask you to connect.
Now when you are typing code in SQL you have real auto-complete and Intellisense!