I am calling a SP from BizTalk that returns XML without actually storing it in any tables. So I am returning the XML the SP is creating on the fly. I am however getting the error:
Event Type: Warning
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5740
Date: 21/05/2009
Time: 11:45:16
User: N/A
Computer: XXXX
Description:
The adapter “SQL” raised an error message. Details “HRESULT=”0x80004005″ Description=”Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.”
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Any help will be fantastic.