SQL Server Security

Audit Settings

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