distribution agent giving error like unable to update sp...
can any one suggest which data will delete from which talbles and replication should work normally.
John,
please can you post up the exact error message you receive, and any
'special' configuration settings you have.
TIA,
Paul Ibison
Showing posts with label unable. Show all posts
Showing posts with label unable. Show all posts
Friday, February 24, 2012
Tuesday, February 14, 2012
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!
'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!
Subscribe to:
Posts (Atom)