MSDE and TransactionScope  
Author Message
Asary





PostPosted: Top

ADO >> MSDE and TransactionScope I have a C# application that applys a set of scripts to a database to create
the structures. When each script is applied, I encapsulate the call within a
TransactionScope. Everything works fine on SQL Server 2000 sp4, 2005 sp1,
and Express 2005 sp1 databases.

On MSDE2000 SP4, I consistently get transaction timeouts on my scripts.
However, it is never the same script. These are the same scripts I use on
other database, so I am confident that the scripts themselves are fine.
Everything is running locally on one machine. MSDTC is running. I've tried
restarting the services, restarting the machines, and connection pooling
seems to be ok, and I'm running out of ideas to check.

Has anyone had a similar experience or can recommend something to check?

- [System.Data.SqlClient.SqlException] {"Import of MSDTC transaction
failed: XACT_E_NOTRANSACTION."} System.Data.SqlClient.SqlException
Number 8509

DotNet251