Hi All,
I have a linked server connection setup from server A to server B. I am able
to select and delete records on server B from server A using this
connection,but, when i attempt to insert a record I get the following error
message. I'm running 2000 on both boxes.
Any help would be greatly appreciated.

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


Thank you,

Elecia

MS Sql Server LazyDBA home page