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"
Related tasks
Preupgrade Tasks
Preparing to Install SAP ASE
Managing Java in the Database During Installations and Upgrades