You can take a snapshot of your audit settings on demand, to meet immediate audit needs or diagnose issues.

To capture an audit snapshot:

  1. Click Auditing on the menu bar, and then select Capture Audit Snapshot.
  2. Specify whether you want a snapshot of audit settings for all registered SQL Server instances or for a specific instance, and then click OK.
  3. Review the newly captured snapshot.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels