2308124 - Msg 226, 208 when running sp_help in chained transcation mode | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2308124 - Msg 226, 208 when running sp_help in chained transcation mode

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

SAP Adaptive Server Enterprise 16.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.