Use these system procedures to manage the auditing process:
sp_audit enables and disables auditing options. This is the only system procedure required to establish the events to be audited.
sp_displayaudit displays the active auditing options.
sp_addauditrecord adds user-defined audit records (comments) into the audit trail. Users can add these records only if a System Security Officer enables ad hoc auditing with sp_audit.
