Symptom
- sp_audit says it is "off", even though it is "on"
- 1> exec sp_audit "bind", "all", db1
2> go
Database-specific auditing 'bind' in database 'db1' is 'off'.
(return status = 0) - sp_audit is enabled or turn on
1> exec sp_audit "bind", "all", db1 ,"on"
2> go
Audit option has been changed and has taken effect immediately.
(return status = 0) - It still says it is "off", it should be "on"
1> exec sp_audit "bind", "all", db1
2> go
Database-specific auditing 'bind' in database 'db1' is 'off'.
(return status = 0)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
sp_audit, java, on, off, stored procedure, CR738033, CR#738033, 738033 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.