Sql Code Guard is a free addin for SSMS (2005/2008/2008R2/2012)* that's provides fast and comprehensive static analysis for T-Sql code, shows code complexity and objects dependencies
* Visual studio 2010 and database project are also supported

Great news! Now SqlCodeGuard provides simple basic API to use its powerful analyze abilities in yours custom solutions! (assembly and sample project included)

Don't be shy - download Sql Code Guard 2.1.4804 (updated 2013-02-25) right now (changelog)
Do you have any suggestions? Bugreport? Feel free to contact me SqlCodeGuard@gmail.com
Code issues

Code issues

Want to be sure that your code is “best practice” compliant?
Need check for hidden pitfalls?
There it is – Code issues window!
You can analyze as single script and the entire database with only few mouse clicks!
More than hundred of rules to check – from stylish to potential errors
Dependencies

Object dependencies

Wondering who use this table? Procedure? Function?
Or maybe you want to know – which procedures makes modification to this table or view?
Trying to omit well-known error 208? Want to know if you missed some objects?
Object dependencies are right for you!
Explore your database with single mouse click!
Code complexity

Code complexity

Worried about you code? It seems too complex to understand?
Find complexity of your code!
In combination with Code outline you can fast and easy find most complex procedure or function in your database and review it.

Code outline

Code Outline

Lost in your “too-complex-to-navigate” procedure?
Use Code Outline for quick and simple navigation through workflow of your code!
Complexity analyze of each navigated statement provided!