Reenable all auditing options for stored procedures using the audit options you recorded during pre-installation. Reenter the audit options using sp_audit.
Adaptive Server 12.5.x and later includes the following global audit options for sp_audit:
security
dbcc
The functionality provided by these obsolete sp_configure "auditing", 0 options is now covered by the sp_audit security global audit option:
server boot
role toggle
These options are turned off by default and are not turned on even if you used sp_configure "auditing", 0 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: Procedures.
If any of these options were turned off before the upgrade, reset the security option to on to achieve the same auditing actions.
