BizTalk Server Applications Integration - SQL Adapter executing select statement - no need for transaction enlistment

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > January 2006 > SQL Adapter executing select statement - no need for transaction enlistment





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author SQL Adapter executing select statement - no need for transaction enlistment
anetasalomonsen@hotmail.com

2006-01-27, 9:28 pm

I have a BizTalk 2004 orchestration with an SQL Adapter witch executes
a stored procedure. This stored procedure just retrieves some data from
a SQL Server database by a simple select. There is a firewall between
the BizTalk machine and the SQL Server machine.

Because this is just a select, there is no need for BizTalk to enlist
any transaction with the SQL Server. Is there a way to turn transaction
enlistment off for this sql-adapter?

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com