We need to use the sp_procxmode in our stored proceudres when we are working with Progress Sonic.

Def

How or change the transaction mode for a stored procedure.

Samples

— all procs
sp_procxmode

— show the mode of a proc
sp_procxmode SPR_SAMPLE

— alter the mode of a proc
sp_procxmode SPR_SAMPLE, ‘anymode’ 

😀