If the server you upgraded from was configured for auditing,
reenable auditing in the upgraded server.
Enter:
sp_configure 'auditing', 1
Reenable auditing
for all system stored procedures for which auditing was enabled
before the upgrade.
Use the output of sp_displayaudit recorded
during preupgrade 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: