i'd like to introduce SqlCodeGuard - free addin for SSMS and VS2010.
It provides fast and comprehensive static analysis for T-Sql code (more than hundred rules), shows code complexity, code outline (with navigation) and objects dependencies.
Installation package and a little bit more information can be found at http://www.sqlcodeguard.com/
Your feedback will be invaluable
Thank you for your attention