• I have a similar situation.

    I plan to look into the "SQL Compliance Manager" product by Idera. I haven't evaluated it yet, other than reading their datasheet, so I can't offer an opinion about it one way or another.

    http://www.idera.com/Products/SQLcm/

    I currently use their SQLdm SQL Diagnostic software and have been pleased with it.  Like many of these types of products, they don't really tell you things you can't obtain otherwise, but they wrap them up into a convenient package that is easy to use.  So if you're not into "rolling your own" DB utilities and can spend some money it may be a reasonable solution.