Reenable all auditing options for stored procedures using the audit options you recorded during pre-installation. See “Disable auditing”. Reenter the audit options using sp_audit.
Adaptive Server 12.5 includes the following global audit options for sp_audit:
These options are turned off by default and will not be turned on even if you used sp_auditoption all to turn on all global audit options in a version earlier than 11.5.
To turn on these options, use:
1> sp_audit security "on" 2> go 1> sp_audit "dbcc" "on" 2> go
For more information, see the Reference Manual.
The functionality provided by these obsolete sp_auditoption options is now covered by the sp_audit security global audit option:
The security option is turned off by default.
If any of these options were turned off before the upgrade, reset the security option to on to achieve the same auditing actions.