title: BizTalk WCF SQL Adapter Message Transaction Setting
body: <p>I'm working on a BizTalk solution where by all transactions are long running calling the WCF SQL Adapter. In some instances we perform updates and we have <code>useAmbientTransaction</code> set to True. It's my understanding that the means we are using MSDTC. The issue we have is that our technical team don't like the idea of opening the number of ports in the firewall to enable MSDTC as apparently they are quite numerous. </p>
  
  <p>The thing is, if we set the Use Transaction on the Message Tab to unchecked the transactions appear to work even though <code>useAmbientTransaction</code> on the bindings to true and all the MSDTC ports are still closed. I haven't been able to find any blogs or references to this so I'm hoping someone could explain how this could be the case.</p>
  
  <p>To be clear, we are not performing multiple SQL calls as part of a single transaction. It's only one SQL call per request. The SQL server is on a different environment from the BizTalk server.</p>