Member Avatar for Tank50

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
  • 124 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by Tank50
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.