I have written a utility that checks our stored procedures for
potentially incorrect code (eg = null as opposed to is null, unused
variables/parameters etc). It also ensures that parameters/variables
etc match our naming conventions and data types/sizes are the sames as
the corresponding type in the database (if appropriate)

Are there any other utilities that do this sort of thing?

PromisedOyster@hotmail.com (Mystery Man) wrote in message news:<87c81238.0407081943.17654baa@posting.google. com>...
> I have written a utility that checks our stored procedures for
> potentially incorrect code (eg = null as opposed to is null, unused
> variables/parameters etc). It also ensures that parameters/variables
> etc match our naming conventions and data types/sizes are the sames as
> the corresponding type in the database (if appropriate)
>
> Are there any other utilities that do this sort of thing?

The MS Best Practices Analyzer does some of those things, as well as
looking at system settings and configuration:

http://www.microsoft.com/downloads/d...displaylang=en

Simon