Do you know Red Gate SQL Prompt? It is Intelli-sense (and much more like refactoring, validation, dependencies, ...) into SSMS (SQL Server Management Studio).

They just released version 5 of this great product. I just can't live without it!

You can check by yourself the complete feature list and download a 14-days trial version from http://www.red-gate.com/products/sql-development/sql-prompt/.