tags:

views:

21

answers:

1
Q: 

DTC transaction escalation

Hi,

I am using TransactionScope. Within that scope, there are several different database connections. But all this connections on the same physical server and on the same Sql Server instance. The difference in connections is only in databases. Is this transaction will be DTC transaction?

+1  A: 

Suggest you take a look at some of the other questions on the same topic, like this one:

TransactionScope automatically escalating to MSDTC on some machines?

David M  2010-01-08 10:02:13

related questions

transaction isolation problem or wrong approach?
SQL Server 2000 and System.Transactions.TransactionScope()
How do I use a remote MSMQ transactionally?
Distributed Processing: C++ equivalent of JTA
What is the 'best' way to do distributed transactions across multiple databases using Spring and Hibernate
When do transactions start when using (restful) rails
IsolationLevel.RepeatableRead to prevent duplicates
EJB3 Transaction Propogation
Properly scoped transactions in Stored Procs
SQL Server sys.databases log_reuse_wait question
When do transactions become more of a burden than a benefit?
How to prevent an Insert query from enrolling into a Distributed Transaction?
JPA Multiple Transaction Managers
What are the problems of using transactions in a database?
Wrap an Oracle schema update in a transaction
Nested SQL Server transaction performing cascade delete
Update schema and rows in one transaction, SQL Server 2005
How do distributed transactions work (eg. MSDTC)?
Looking for a SQL Transaction Log file viewer
Propagation of Oracle Transactions Between C++ and Java
Is SQL Server Bulk Insert Transactional?
Transactions best practices
Transactional Design Pattern
Is it possible to share a transaction between a .Net application and a COM+ object?
Unit-Testing Databases