var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Distributed Transaction
I am trying to access a table in another server and I keep getting this error msg.
'THE OLEDB provider was unable to begin a distributed transaction'
I have a linked server and I am using Microsoft OLE DB Provider for SQL Server.
Anyone can help?
can you give an example as to the way you are trying to access the other table on the 'b' server?
What T-SQL statement are you trying to use?
I was trying to INSERT. Does that only work for SELECT?!
Basically i was trying to use the statement below where AP2K380 is my linked Server.
insert into AP2K380.asiapac702_test.dbo.tblCustServiceHistoryH dr
and I ran into an error saying that the SQLOLEDB was unable to being a distributed transaction.
Pls help...thanks a million!