Intellisense in SQL Server Management Studio

SQL Prompt is a handy tool that adds intellisense functionality to your SQL Server Management Studio. After changing some settings, it becomes a real time saver.

Unfortunately, it is no longer for free.
Info: http://www.red-gate.com/products/SQL_Prompt/index.htm