Biztalk SQL Port

See more:

SQL-Server-2005

SQL-Server

, +

Hi,

I have a simple orchestration with a SQL port to connect a little Procedure. The problem is that the procedure has a transaction inside, and a try catch too. If the procedure runs ok, no problem, if there is a problem and the procedure "calls" a rollback, biztalk raises a error:

Details:"HRESULT="0x80004005" Description="Cannot roll back TDOC. No transaction or savepoint of that name was found."

If I run in SQL Server works fine, but in Biztalk no, I´m sure that the sql port in bzt open a transaction, I would like to disable the transaction in the sql port, is it possible????

Thank you very much