Do you want Intellisense in SQL Server Management Studio, Query Analyzer and SQL queries in VS similar to Visual Studio?  Then check out this great product from Red Gate Software at http://www.sqlprompt.com/!