SQL Code Guard is a free addin for SSMS (2005/2008/2008R2/2012) and VS2010 that's provides fast and comprehensive static analysis for T-Sql code, shows code complexity and objects dependencies Also SQL Code Guard provides API for custom tool development and basic integration with msbuild (demo projects can be found in SQL Code Guard folder).Breaking news! SQL Code Guard is now part of Red Gate ecosystem project! (framework is included in SCG installation package)
If you have any idea about new features, improvements etc feel free to contact me at SqlCodeGuard@gmail.com
Would you like confidence that your code adheres to your “best practices”, and be warned of hidden pitfalls?
Use the Code issues feature to analyze a single script or the entire database! There are over a hundred rules covering both style issues and potential errors.
Wondering which objects use or modify a table, view, procedure, or function? Trying to avoid Error 208?
Object dependencies allows you to explore your database with a single mouse click!
Worried about you code? Does it seem too complex to understand?
Now you can Complexity check your code! In combination with Code outline, you can quickly find your most complex procedures or functions and review them.
Lost in your “too-complex-to-navigate” procedure?
Use Code outline for quick and simple navigation through the workflow of your code!