Edit

Share via

DROP SERVER AUDIT (Transact-SQL)

  • Article

Applies to: SQL Server Azure SQL Managed Instance

Drops a server audit object using the SQL Server Audit feature. For more information on SQL Server Audit, see SQL Server Audit (Database Engine).

Transact-SQL syntax conventions

Syntax

syntaxsql 
DROP SERVER AUDIT audit_name
[ ; ]

Remarks

You must set the State of an audit to the OFF option in order to make any changes to an Audit. If you run DROP AUDIT while an audit is enabled with any options other than STATE = OFF, you receive a MSG_NEED_AUDIT_DISABLED error message.

A DROP SERVER AUDIT removes the metadata for the Audit, but not the audit data that was collected before the command was issued.

DROP SERVER AUDIT doesn't drop associated server or database audit specifications. These specifications must be dropped manually or left orphaned and later mapped to a new server audit.

Permissions

To create, alter, or drop a Server Audit Principal, you need ALTER ANY SERVER AUDIT or CONTROL SERVER permissions.

Examples

The following example drops an audit called HIPAA_Audit.

SQL 
ALTER SERVER AUDIT HIPAA_Audit
WITH (STATE = OFF);
GO

DROP SERVER AUDIT HIPAA_Audit;
GO

Transact-SQL reference

Related content