Udalosti
31. 3., 23 - 2. 4., 23
Najväčšia vzdelávacia udalosť pre SQL, Fabric a Power BI. 31. marec – 2. apríl. Pomocou kódu FABINSIDER ušetríte 400 USD.
Zaregistrujte saTento prehliadač už nie je podporovaný.
Inovujte na Microsoft Edge a využívajte najnovšie funkcie, aktualizácie zabezpečenia a technickú podporu.
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
DROP SERVER AUDIT audit_name
[ ; ]
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.
To create, alter, or drop a Server Audit Principal, you need ALTER ANY SERVER AUDIT
or CONTROL SERVER
permissions.
The following example drops an audit called HIPAA_Audit
.
ALTER SERVER AUDIT HIPAA_Audit
WITH (STATE = OFF);
GO
DROP SERVER AUDIT HIPAA_Audit;
GO
Udalosti
31. 3., 23 - 2. 4., 23
Najväčšia vzdelávacia udalosť pre SQL, Fabric a Power BI. 31. marec – 2. apríl. Pomocou kódu FABINSIDER ušetríte 400 USD.
Zaregistrujte sa