title: Calling linked server from trigger
body: <p>I've created <code>instead of trigger</code> in server A, in which I call a procedure, which in turn calls other procedure in linked server (server B).</p>
  
  <p>Trigger(A) -> Procedure (A) -> Procedure (B)</p>
  
  <p>But, when trigger executes it throws following error:</p>
  
  <blockquote>
    <p>OLE DB provider "SQLNCLI11" for linked server "xxx" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
    Msg 7391, Level 16, State 2, Line 1
    The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "xxx" was unable to begin a distributed transaction.</p>
  </blockquote>
  
  <p>When I do this: Procedure (A) -> Procedure (B) it works perfectly. What can be the reason?</p>
  
  <p>How can I fix this? Is distributed query differ from Linked server query?</p>