Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DROP DATABASE AUDIT SPECIFICATION (Transact-SQL)
Collapse the table of content
Expand the table of content

DROP DATABASE AUDIT SPECIFICATION (Transact-SQL)

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

Topic link icon Transact-SQL Syntax Conventions

DROP DATABASE AUDIT SPECIFICATION audit_specification_name
[ ; ]

audit_specification_name

Name of an existing audit specification object.

A DROP DATABASE AUDIT SPECIFICATION removes the metadata for the audit specification, but not the audit data collected before the DROP command was issued. You must set the state of a database audit specification to OFF using ALTER DATABASE AUDIT SPECIFICATION before it can be dropped.

Users with the ALTER ANY DATABASE AUDIT permission can drop database audit specifications.

A. Dropping a Database Audit Specification

The following example drops an audit called HIPAA_Audit_DB_Specification.

DROP DATABASE AUDIT SPECIFICATION HIPAA_Audit_DB_Specification;
GO

For a full example of creating an audit, see SQL Server Audit (Database Engine).

Community Additions

ADD
Show:
© 2015 Microsoft