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 "126.96.36.199" 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 "188.8.131.52" was unable to begin a distributed transaction.
without using Tigger I instert the record into table but it never generate error.
INSERT [184.108.40.206].[Test].dbo.Login VALUES ('Test','Test')
Above Statement work fine whithout giving any error message.Please help me to sort this problem.