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.
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.
ReleaseAugust 31, 2012
Date AddedAugust 30, 2012
Operating SystemsWindows 2003, Windows Vista, Windows, Windows Server 2008, Windows 7, Windows XP