Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How to use Triggers in DTC

manojukmanojuk Member Posts: 2
I am facing a problem while executing a trigger between 2 Linked SQL Servers. I am able to do Select, Insert, call stored procedures in a linked server. But triggers are not getting executed.

The scenario is as follows:

There are 2 servers (A, B) (with win 2003) both having SQL Servers 2000.

Server A has a database called TestDBA with a table called TestA. This contains a trigger on insert, which inserts a record to the table TestB.

Server B has a database called TestDBB with a table called TestB.

I have created a link between these 2 servers using sp_addlinkedserver stored procedure. So the connection is established.



But the trigger is not getting executed. I am getting an error like The operation cannot be performed because the OLE DB Provider MSDASQL was unable to begin a distributed transaction.

But i am able to run a select, insert,.. statements between these 2 servers. Also was able to execute a stored procedure of TestB from TestA.

Thanks for any help
Sign In or Register to comment.