ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Disables auditing of specific events.
sa_disable_auditing_type ( [ string ] )
stringis a comma-delimited string containing one or more of:
all disables all types of auditing.
connect disables auditing of both successful and failed connection attempts.
connectFailed disables auditing of failed connection attempts.
DDL disables auditing of DDL statements.
options disables auditing of public options.
permission disables auditing of permission checks, user checks, and setuser statements.
permissionDenied disables auditing of failed permission and user checks.
triggers disables auditing in response to trigger events.
DBA authority required
None
You can use the sa_disable_auditing_type option to disable auditing of one or more categories of information.
Setting this option to all disables all auditing. You can also disable auditing by setting the public.auditing option to OFF.