Using Trigger With Linked Server

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

I use one trigger with liked server,
one server is SQL Server 2000 and another linked server is SQL Server 2005 these two server i already link. These trigger is use after insert data.
But now ,i facing the following problem.

CSS

OLE DB provider 'SQLOLEDB' was unable to begin a distributedtransaction

[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 0 8004d00a]

Best Regard,
Theingi Win.

Posted 10-Aug-11 21:16pm

Theingi Win

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-08-10T21:25:00

Solution 1

First thing is to check that MS DTC service is up and running. Also check these:
- http://support.microsoft.com/kb/839279[^]
- http://support.microsoft.com/kb/329332[^]

Posted 10-Aug-11 21:25pm

Wendelius

Comments

Theingi Win 11-Aug-11 3:33am

Thanks ! Mika Wendelius

I want to ask you. This DTC service is need to run both server or not.

Wendelius 11-Aug-11 3:40am

In order to handle transaction enlistment both ways, yes.

Theingi Win 11-Aug-11 3:41am

Thanks! for your reply
i will try it.

Using Trigger With Linked Server

1 solution

Solution 1

Add your solution here

Preview 0

Using Trigger With Linked Server

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us