Unanswered: Unable to begin Distributed Transaction
I am trying to insert data into a table on another Server(eg. Server B)
through a trigger on a table in Server A. I have already created a linked server for Server B and hence i use a four part name(eg. serverB.Dbname.dbo.tablename) in my trigger. But I get an error saying that "SQLOLEDB is unable to begin the distributed transaction". What could be wrong....someone pls advise.
MSDTC is running on both servers and I have already added the code SET XACT_ABORT ON to my trigger code. I even tried removing the BEGIN DISTRIBUTED TRANSACTION and COMMIT TRAN tags off my code but no use. Here is an excerpt of my code.
SET ANSI_DEFAULTS ON
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET XACT_ABORT ON
BEGIN DISTRIBUTED TRANSACTION
insert into AP2K380.asiapac702_test.dbo.tblCustServiceHistoryH dr(