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.