November 2006 Entries

ROLLBACK in the stored procedures started by BizTAlk SQL port

ROLLBACKs create the interesting events. I've spent a time trying to understand them. When I've tried to use BEGIN TRAN MAIN...ROLLBACK TRAN MAIN inside of the SP, that is started by BizTAlk SQL port, And I've got couple events: (they are bellow) It was interesting as this SP has done ROLLBACK if I test it without BizTalk. I've got the description of this situation in the BizTalk 2006 Help:"Save Tran and RollBack tran in stored procedures will cause an error event from the SQL adapter, but the transaction ......