SQL Server Auditing: A Learning Series Part Seven
Continuing our learning series on auditing, today we look at how to query the audit information from the server.
- sys,server_audits displays information on the audits setup on the server.
- sys.server_audit_specifications displays information on the audit specification setup on the server.
- sys.server_audit_specification_details display detailed information about the specifications.
- sys.dm_server_audit_status displays information about the status of your audits.
Enjoy and stay tuned!
Posted on January 24, 2013, in Auditing and tagged Auditing, security. Bookmark the permalink. Leave a comment.
Leave a comment
Comments 0