ENV:
ServerA:
Windows 2000 server, MS SQL SERVER 2000 SP4
ServerB:
Windows 2000 server, MS SQL SERVER 2000 SP4

Question:
I have TableA on ServerA, TableB on ServerB.
I make linked Server on both Server.
I can insert into ServerB.TableB on ServerA.
But if I exec the same sql in A trigger on Server A.

It Show MSG:

Server: Msg 7391, Level 16, State 1, Line 1
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].


I run DTS as Services on both server.

What Can I do?

Thank a lot!