====== SQL Server Security ======

=== Audit Settings ===

<code sql>
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
</code>