Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Auditing Products for SQL Server

By:   |   Read Comments (1)   |   Related Tips: More > Auditing and Compliance

SQL Server Indexing Tips and Tricks --- Free MSSQLTips Webcast!

With the many needs (SOX, HIPAA, internal, etc.) for auditing sensitive data, what are the options available in the market place to audit SQL Server data and code changes?  Do these products automatically collect the data as well as build reports and selectively alert on critical issues?

Below outlines the SQL Server auditing products on the market with URL's to the product for more information.

ID Offering Data Changes Code Changes Auto Data Collection Reporting Real Time Alerting
1 ApexSQL Audit *   * *  
2 GridApp Clarity's Auditing and Compliance * * * * *
3 Idera Compliance Manager * * * * *
4 Imperva * * * * *
5 Lumigent Audit DB * * * * *
6 Quest Software SQL Watch   * * * *
7 SQL Server Profiler * * *    
8 SQL Server Triggers * * *    

If you know of additional SQL Server auditing products on the market, please let us know and we will update this tip.  Please email the product\technology\tool to [email protected].

Next Steps

Last Update:

signup button

next tip button

About the author
MSSQLTips author Jeremy Kadlec Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an Edgewood Solutions SQL Server Consultant, MSSQLTips.com co-founder and Baltimore SSUG co-leader.

View all my tips
Related Resources

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 

Send me SQL tips:


Saturday, February 08, 2014 - 9:55:18 AM - Panayiotis Hiripis Back To Top

Hi all,

  I believe you should include Sql Server's change tracking feature. Basically, it is an internal triggerless mechanism to observe dml changes to all tables of a database, with a purging mechanism.   http://technet.microsoft.com/en-us/library/bb933875.aspx   and   http://msdn.microsoft.com/en-us/library/cc305322.aspx

Learn more about SQL Server tools