Symptom
The sp_help system procedure fails with the following messages when executing in chained transaction mode:
Msg 226, Level 16, State 1:
Server 'xxx', Procedure 'sp_help', Line 288:
SELECT INTO command not allowed within multi-statement transaction.
Msg 208, Level 16, State 1:
Server 'xxx', Procedure 'sp_help', Line 1:
#sphelp5rs not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
Msg 208, Level 16, State 6:
Server 'xxx', Procedure 'sp_help', Line 483:
#sphelp5rs not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
(return status = -6)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
226, help; sp; "system procedure"; proc; set; , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.
SAP Knowledge Base Article - Preview