I am planning on using SQL Audits on the servers I manage and to have a more uniformed approach on setups, I was planning and writing my own management program in C#. Just wanted to check before I begin, that nobody else has thought of this and has released an open source tool.

My plan was to have something that would create Audits, Audits Specifications and some sort of data collection into a database. I've looked at Idera's Compliance Manager but that was too expensive for us to purchase.

Has anyone come across something like this before?

  • What are the additional functionalities that you plan adding with the C# program over native SSMS / DMV.
    – DMDM
    Sep 11, 2017 at 10:09
  • I wasn't planning anything that you can't do with SSMS but just something that would allow me to roll out that same specifications to to each database on every server (Enterprise only). Sep 11, 2017 at 10:12
  • Are you confusing with Administer Servers by Using Policy-Based Management? Sep 12, 2017 at 0:20
  • To be honest I never thought of using that. I'll have a look and see what it can do Sep 12, 2017 at 9:38
  • I've looked at policy based management it rolling out polices using it seems a bit beyond it capabilities. I think I will stick with SMO and write my own program. Found this Blog that shows how to do it in Powershell. Sep 12, 2017 at 14:31


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.