linkedserver error

Hi

Im sorry if im in the wrong section. My problem is a very common one and it has been hard for me to find the fix.

Ive gone thru Component Services, Firewall settings, Registry and Microsoft Sites, but to avail.

"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]."

My Begin Tran doesnt start at all.

begin tran
use smartpos
go

set identity_insert smartpos.dbo.smp_product on

insert into smartpos.dbo.smp_product
(prodId
,[Description]
,barcode
,BuyPriceExclVat
,BuyPriceVatTYpeId
,point
,SupplierID
,Ref
,QtyType
,QtyFactor
,MinStock
,MaxStock
,Active
,ItemType
,ClientLastUpdate
)
select prodId
,[Description]
,barcode
,BuyPriceExclVat
,BuyPriceVatTYpeId
,point
,SupplierID
,Ref
,QtyType
,QtyFactor
,MinStock
,MaxStock
,Active
,ItemType
,LastUpdate
from server.smartpos.dbo.smp_product svr
where not exists (select prodid from smartpos.dbo.smp_product where prodid=svr.prodid)

set identity_insert smartpos.dbo.smp_product off

Can anyone help me please.

Thanks

I am having the same problem. I was able to work around it by selecting the rows into #tmp and then inserting from #tmp into the destination table. Not exactly pretty but it worked for me.

|||

Hello idezignx,

you may need to read this.

Hope Useful.

try it.

http://support.microsoft.com/kb/839279/en-us

sql