SQL Code Guard is a free solution for SQL Server that's provides fast and comprehensive static analysis for T-Sql code, shows code complexity and objects dependencies
It provides:

  • Integration with SSMS 2005/2008/2012/2014
  • Integration with Visual Studio 2010/2012
  • Checkin Policy for TFS (how to install & use)
  • Support of msbuild (how to use msbuild)
  • API for custom tool development (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 don't hesitate to contact us at SQLCodeGuard@gmail.com

    Follow us on Twitter @SQLCodeGuard and Blogspot to stay informed about any news

    download
    Current:SQL Code Guard 2.4.5222
    Date:2014/04/19
    License:Read
    Changelog:View

    Code issues

    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.

    Object dependencies

    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!

    Code complexity

    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.

    Code outline

    Lost in your “too-complex-to-navigate” procedure?
    Use Code outline for quick and simple navigation through the workflow of your code!