Reenabling Auditing

If the server you upgraded from was configured for auditing, reenable auditing in the upgraded server.

1. Enter:

   sp_configure 'auditing', 1

2. Reenable auditing for all system stored procedures for which auditing was enabled before the upgrade.
   1. Use the output of sp_displayaudit recorded during the preupgrade process to identify the system stored procedures for which auditing was enabled.
   2. Reenter the audit options using sp_audit. For example, if you had enabled stored procedure auditing for sp_addgroup stored procedure in your server before upgrading, run:

      sp_audit "exec_procedure", "all", "sp_addgroup", "on"

• Updating Threshold Procedures for Audit Segments
  An post-upgrade task is required for threshold procedures used to archive audit segments.