TransactionScope automatically escalating to MSDTC on some machines?

by

SQL Server 2008 can use multiple SQLConnections in one TransactionScope without escalating, provided the connections are not open at the same time, which would result in multiple “physical” TCP connections and thus require escalation.

I see some of your developers have SQL Server 2005 and others have SQL Server 2008. Are you sure you have correctly identified which ones are escalating and which not?

The most obvious explanation would be that developers with SQL Server 2008 are the ones that aren’t escalating.

More Related Contents:

  1. How to use TransactionScope in C#?
  2. How does TransactionScope roll back transactions?
  3. “The operation is not valid for the state of the transaction” error and transaction scope
  4. C# – System.Transactions.TransactionScope
  5. Transactions in .net
  6. C# controlling a transaction across multiple databases
  7. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  8. TransactionScope With Files In C# [duplicate]
  9. What’s wrong with using Thread.Abort()
  10. HttpClient.GetAsync(…) never returns when using await/async
  11. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  12. Can I make XmlSerializer ignore the namespace on deserialization?
  13. Extracting mantissa and exponent from double in c#
  14. Format Number like Stack Overflow (rounded to thousands with K suffix)
  15. Why we need Thread.MemoryBarrier()?
  16. convert double to int
  17. .NET ObservableDictionary
  18. What is the correct way to read from NetworkStream in .NET
  19. WCF Service Client: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding
  20. A reproducible example of volatile usage
  21. System.Threading.Timer in C# it seems to be not working. It runs very fast every 3 second
  22. ArgumentOutOfRangeException on initialized List
  23. Guidelines For Dispose() and Ninject
  24. How to check if a DLL file is registered?
  25. ReaderWriterLock vs lock{}
  26. Using multiple instances of MemoryCache
  27. How to log Trace messages with log4net?
  28. Why do arrays in .net only implement IEnumerable and not IEnumerable?
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. Call has been made on garbage collected delegate in C#?

Leave a Comment