Enables auditing and specifies which events to audit.
sa_enable_auditing_type( ['string ] )
string is a comma-delimited string.
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
sa_enable_auditing_type works with the PUBLIC.AUDITING option to enable auditing of specific types of information.
If you set the PUBLIC.AUDITING option to ON, and do not specify which type of information to audit, the default setting (all) takes effect. In this case, all types of auditing information are recorded.
If you set the PUBLIC.AUDITING option to ON, and disable all types of auditing using sa_disable_auditing_type, no auditing information is recorded. To re-establish auditing, use sa_enable_auditing_type to specify which type of information you want to audit.
If you set the PUBLIC.AUDITING option to OFF, then no auditing information is recorded, regardless of the sa_enable_auditing_type setting.
To enable only option auditing:
sa_disable_auditing_type('all')
sa_enable_auditing_type('options')
AUDITING option [database] in Chapter 2, “Database Options,” in Reference: Statements and Options
