Re: Linked Server : SQL Server 2000
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: Wed, 4 Feb 2004 11:19:20 -0500
Is the Distributed Transaction Coordinator running? On both servers? And
is it configured according to:
A discussion of linked servers can be found in the article "Linked Servers
and Distributed Transactions"
"Venugopal" <firstname.lastname@example.org> wrote in message
> 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
> [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