The Disassemble Result Set option does not work when you request many records in BizTalk Server (814804)

SYMPTOMS

If you select the Disassemble Result Set option, and then you request many records, the SQL request does not succeed and you receive the following event error message in the application log file of your computer that is running Microsoft BizTalk Server: Source: RFSQL
Type: Error
Event ID 10
Category: None

Description:
A worker thread reported a failure: [Error:] An error occurred in BizTalk Server.
Details:
------
BizTalk Server failed to initialize a connection to database: "InterchangeSQ" on server: "FRLAB108". :'New transaction cannot enlist in the specified transaction coordinator. ' There was a failure creating the internal work item. Make sure that SQL Server is running. [Source:] [HelpFile:] [HelpContext:] 0 Note: The Disassemble result set feature can not be used if the target SQL Server is the same one that BizTalk uses. In this case you must unselect the Disassemble Rresult Set feature. The error code is shown in the data area below. The operation was: ISQLWorker->Execute The worker thread was working on: Job Name: select * from northwind SQL Script: select * from products for xml autoNote In this message, "Rresult" is a misspelling of the word "Result."