If the server you are upgrading from was configured for auditing, reenable auditing in the upgraded server using the following command:
sp_configure 'auditing', 1
Installing system stored procedures drops audit information about the system stored procedures. You should reenable auditing for all system stored procedures for which auditing was enabled before upgrade. Use the output of sp_displayaudit recorded during pre-upgrade to help determine the system stored procedures for which auditing was enabled. Reenter the audit options using sp_audit.
For example, if you had enabled stored procedure auditing for sp_addlogin stored procedure in your server before upgrade, run the following sp_audit command to reenable auditing on sp_addlogin:
sp_audit "exec_procedure", "all", "sp_addlogin", "on"
