0

Hi

I Create the tigger when update process happen in database.When the after update process happened ,tigger instert the new record into another table about that table locate in different server.I create linked server also ,once tigger execute it generate the Error message .Below I mention the error Message I got

OLE DB provider "SQLNCLI" for linked server "123.123.123.123" returned message "The transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Procedure tr_Source_INSERT, Line 5
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "123.123.123.123" was unable to begin a distributed transaction.

without using Tigger I instert the record into table but it never generate error.
INSERT [123.123.123.123].[Test].dbo.Login VALUES ('Test','Test')
Above Statement work fine whithout giving any error message.Please help me to sort this problem.

Thanks
Tank50

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by Tank50
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.