Debug Error "Stored Procedure 'procedure name' may be run only in unchained transaction mode..." (4311547)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Debug Error "Stored Procedure 'procedure name' may be run only in unchained transaction mode..."
Description

The following error occurs when trying to debug a stored procedure:

"Stored procedure 'procedure name' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode"
Resolution

Set the stored procedure mode to 'anymode' using the following command.

sp_procxmode "procedure_name", "anymode"

If you are unable to run command sp_procxmode, contact your database administrator to arrange this.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title