Sql Code Guard is a free addin for Sql Server Management Studio (2005/2008/2008R2) that's provides fast and comprehensive static analyze for T-Sql code, shows code complexity and objects dependencies. Also provides API to incorporate checks in your own solution.
Full Specifications
What's new in version 2.1.46
[*] "Select issues" window made resizable.
[*] Fixed cutting of issues description in "Select issues" dialog.
[+] Added "Dump issues summary"/"Dump issues" to Issue Window context menu.
[+] Added SqlCodeGuardAPI.API.IssueList property to enumerate all defined issues.
General
ReleaseAugust 31, 2012
Date AddedAugust 30, 2012
Version2.1.46
Operating Systems
Operating SystemsWindows 2003, Windows Vista, Windows, Windows Server 2008, Windows 7, Windows XP