Disable auditing

To upgrade a server that contains a database in which auditing is activated, make sure that auditing is disabled before starting the upgrade:

  1. Turn off auditing before upgrading.

    1. Verify that all Adaptive Server users are logged off.

    2. Disable auditing with the following Transact-SQL command:

      sp_auditoption 'enable auditing', 'off'
      
  2. Record system procedure audit options before upgrading.

    When upgrading, all previous versions of system procedures are overwritten when sybsystemprocs is populated. Record the audit options for all system procedures. After the upgrade is complete, shut down and restart the server. Reenable auditing using:

    sp_configure auditing, 1
    

    You can reenter the audit options, using sp_audit. For more information, see the System Administration Guide.