SqlCodeGuard

Designed as a free add-in for Sql Server Management Studio (SSMS), SqlCodeGuard helps you analyze T-Sql code and identify possible errors to fix. It's similar to ReSharper for C#.

The program is capable of scanning code to locate complex procedures and functions, in order to prepare them for project reviewing. It offers support for code issues, complexity and outline, along with object dependencies.

Apart from Sql Server Management Studio, you must have .NET Framework 4.0 installed in order to work with this tool. It can integrate with SSMS 2014, 2012, 2008 and 2008 R2, as well as Visual Studio 2013 and 2012. msbuild is supported, and there's also a command-line interface available, along with an API sample with demo projects for customized development.

As far as the graphical UI is concerned, the add-in adopts a standard window, where you can view decompiled code and spot errors or other types of issues by taking a look at the icon next to each line (yellow exclamation point).

It's possible to find and select issues, group items by object, process the entire database, verify the code's complexity, as well as resort to a basic search tool.