Reenable all auditing options for stored procedures using the audit options you recorded during pre-upgrade. 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"
Adaptive Server 12.5.x and later includes the following global audit options for sp_audit:
security
dbcc
The functionality provided by the following sp_auditoption options is now covered by the sp_audit security global audit option:
server boot
roles
These options are turned off by default and are not turned on even if you used sp_auditoption "all", "on" to turn on all global audit options in a version earlier than 11.5.
To turn on these options, use:
1> sp_audit "security", "all", "all", "on" 2> go 1> sp_audit "dbcc", "all", "all", "on" 2> go
For more information, see the Reference Manual.
