Posted by rbg on 02/01/07 15:30

Hi,
On My local SQL server I have added a linked server to another SQL
server (remoteserver) in another Windows NT Domain.

When I run this code
select count(*) from remoteserver.mosaics.dbo.Location

This works fine.

However when I use
begin transaction
select count(*) from remoteserver.mosaics.dbo.Location

It errors out saying that
The operation could not be performed because the OLE DB provider
'SQLOLEDB' was unable to begin a distributed transaction.
New transaction cannot enlist in the specified transaction
coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].

My question is even though I am just reading data from the
remoteserver, why does the local transaction get promoted to a
distributed transaction.
Any help will be grately appreciated.

TIA...Rohit

• Next in forum: Re: Why transaction gets promoted to Distributed transaction
• Prev in forum: monitoring applications querys
• Thread view: Why transaction gets promoted to Distributed transaction

[Reply to this message]