Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.