Link to the server "* * * * * *" OLE DB access interface "SQLNCLI" return "no active transaction," the news,

Message 7391, level 16, state 2, process trg_ * * * * * * *, line 72

Can't do that, because the link server "* * * * *" OLE DB access interface "SQLNCLI" unable to start a distributed transaction,

The trigger content:
If the update
By inserting data link server:
INSERT INTO link1. Database1. [dbo]. [table1]

Link to the server RPC and RPC out, function opens the


Don't trigger, alone with the INSERT INTO link1. Database1. [dbo]. [table1] success,


How to solve the trigger by connecting to the server to update the table data of another server?

CodePudding user response:

Their top once, in case of heavy water,

CodePudding user response:

To solve this problem is quite complex, stick a similar blog for your reference:
https://blog.csdn.net/qq_24886681/article/details/87928239

Suggest you use stored procedures to modify records, modify the record, by the way, the links on the server record also deal with it,

CodePudding user response:

 
The exec sp_serveroption '[link server name]', 'remote proc transaction promotion', 'false' 

CodePudding user response:

refer to the second floor of gypsy song response:

to solve this problem is quite complex, stick a similar blog for your reference:
https://blog.csdn.net/qq_24886681/article/details/87928239

Suggest you use stored procedures to modify records, modify the record, by the way the link records on the server, and it is also with the

Thanks, clock in DTC setting and after service, can normal use,

CodePudding user response:

reference 3 floor started the first response:

 
The exec sp_serveroption '[link server name]', 'remote proc transaction promotion', 'false' 

Thanks, clock in DTC setting and after service, can normal use,

CodePudding user response:

reference 4 floor zhangran_zr response:

Quote: refer to the second floor of gypsy song response:

to solve this problem is quite complex, stick a similar blog for your reference:
https://blog.csdn.net/qq_24886681/article/details/87928239

Suggest you use stored procedures to modify records, modify the record, by the way the link records on the server, and it is also with the

Thank you, punch DTC setting and after service, can use normally,

You're welcome, it's ok it tieba