Disables auditing of specific events.
sa_disable_auditing_type( ['string ] )
string is a comma-delimited string containing one or more of:
all enables all types of auditing.
connect enables auditing of both successful and failed connection attempts.
connectFailed enables auditing of failed connection attempts.
DDL enables auditing of DDL statements.
options enables auditing of public options.
permission enables auditing of permission checks, user checks, and setuser statements.
permissionDenied enables auditing of failed permission and user checks.
triggers enables auditing after a trigger event.
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
You can use the sa_disable_auditing_type system procedure 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.
