Distributed transaction timeout problem

[ayanmitra2007mindtree]

Dear Community Members,

Ours is a Windows Application where we are using Remoting to connect our application server (running as a Windows Service). We are using SQL Server 2000 SP3 as database. At a certain instance while performing a huge transaction (when our application updates some 9000+ records) we are getting the following error:

at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()



*** Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. ---


The application is basically running on Windows 2003 SBS. This problem has started coming only after all the systems were upgraded to Service pack 2 (without this SP there is no problem). The moment the user uninstalls this service pack, the process is getting completed without any problem.

I understood that this problem is something to do with MS DTC and accordingly updated the Timeout to 600 sec (10 Min) but the problem is not resolved.

Have you faced this problem and found a solution please let me know immediately. I am waiting anxiously for your answer.

Regards
Ayan