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 edition
This 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 long
Thank 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