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"
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.
