Can anyone reproduce this problem?
I'm observing a problem where the DTC bails after ~600s, create a console application and run this against SQL2000...
using System;
using System.Collections.Generic;
using System.Text;
using System.Transactions;
using System.Data.SqlClient;
namespace ConsoleApplicationTXtimeout
{
classProgram
{
staticvoid Main(string[] args){
TransactionOptions transactionOptions =newTransactionOptions();transactionOptions.IsolationLevel =
IsolationLevel.ReadCommitted;//transactionOptions.Timeout = new TimeSpan(0,0,0,30);transactionOptions.Timeout =
newTimeSpan(0);DateTime started =DateTime.Now;using (TransactionScope transactionScope =newTransactionScope(TransactionScopeOption.Required,transactionOptions)){
while (DateTime.Now - started <newTimeSpan(0, 10, 0)){
using (SqlConnection connection =newSqlConnection("Data Source=MyServer;Initial Catalog=MyDatabase;Integrated Security=SSPI")){
connection.Open();
SqlCommand command =newSqlCommand("Update MyTable set MyField = MyField", connection);command.ExecuteNonQuery();
Console.WriteLine(DateTime.Now);System.Threading.
Thread.Sleep(65000);}
// end connection}
// do 10 mins worthtransactionScope.Complete();
Console.WriteLine(DateTime.Now);}
// end TxConsole.ReadLine();}
}
}

