MSDTS Transaction Failed.

Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
server sp4. We are checking the logs for sql server and observe that
sometimes this error is displayed
Error: 8510, Severity: 20, State: 1
Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
Do you know what could be the reason?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
This could be one reason for 8510 errors:
SQL Server error 8510 may be reported unnecessarily
http://support.microsoft.com/default...b;en-us;307802
You are probably running into some other MSDTC problem if 8510 are logged to
SQL errorlogs. You should capture a Profiler trace on both linked servers
(with DTCTransaction and all Warnings and Error events) and review them for
other SQL errors leading up to 8510 errors. Also ensure that all connections
executing linked-server queries have SET XACT_ABORT ON.
Adrian
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uYyL0kGRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi, we have sql server 2000 sp3 std edition installed on a windows 2000
> server sp4. We are checking the logs for sql server and observe that
> sometimes this error is displayed
> Error: 8510, Severity: 20, State: 1
> Enlist of MSDTC transaction failed: Result Code = 0x8004d00e..
> Do you know what could be the reason?
> Thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.codecomments.com ***