Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tushardsarvaiya
Starting Member
3 Posts |
 Posted - 2009-01-20 : 06:41:25
|
| I am getting this Error"Enlist operation failed: 0x8004d00e(XACT_E_NOTRANSACTION). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.A severe error occurred on the current command. The results, if any, should be discarded"I am using windows Xp and sql server 2005 express editionThis error occurs when I am calling a procedure and that procedure is connect other remote sql server by the linked server.I am using ditributed transaction in the Procedure. That's why I have change the Setting of MSDTC for the distributed transaction on both the server and Client PC also. I am calling this procedure in the batch size. Means After 100 records processed I am calling that procedure.Sometimes it is successfully Executed and sometimes it fails and Give me that Error.So If any one can help me I am getting this error for so longThank You. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-01-20 : 07:19:44
|
| Please don't cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=118195 |
 |
|
|
|
|
|
Enlist opration failed