Re: Linked Server : SQL Server 2000

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 02/04/04

Date: Wed, 4 Feb 2004 11:19:20 -0500


Is the Distributed Transaction Coordinator running? On both servers? And
is it configured according to:;en-us;329332

A discussion of linked servers can be found in the article "Linked Servers
and Distributed Transactions"

Russell Fields
"Venugopal" <> wrote in message
> Hi,
> When I try to update a table on my local server by
> referring to another table in the the linked server I get
> a message "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]."
> Any ideas would be appreciated as I am running short of
> time.
> Regards,
> Venugopal