This is an old revision of the document!
SQL Server Security
SELECT name, TYPE FROM sys.server_audits SELECT name AS 'Audit Name', status_desc AS 'Audit Status', audit_file_path AS 'Current Audit File' FROM sys.dm_server_audit_status SELECT * FROM sys.dm_server_audit_status