Linked server problem

Hi,

I am running following script on server A. Server B is configured as linked server to A.

SET xact_abort ON
GO
begin tran
INSERT INTO B.table1.dbo.CUSTOMER (CUSTOMER_ID,PLAN_CODE)
VALUES (1001,100)
rollback tran

The above script when run run on server A gives following error:-
Error..
Server: Msg 7391, Level 16, State 1, Line 3
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

Pls. advise why this error occurs. How to insert records in linked server.

Is the Distributed Transaction Coordinator (MSDTC) service running on both computers?|||yes|||

change begin tran to BEGIN DISTRIBUTED TRANSACTION and see

Madhu

|||that also doesnot work. Is it because A is windows 2003 & B is windows 2000 server?|||

what is the service pack on these box

Madhu

|||

Hi Shah,

If you still have tht problem, here is the link for the solution.

http://support.microsoft.com/?kbid=873160