title: Insert to remote server MSSQL 2005
body: <p>I'd like to insert data in a trigger to a remote mssql 2005 server from my local mssql 2005 server.</p>
  
  <p>I have a table Syr; I creates a trigger (AFTER INSERT) to detect if something has been added to it.
  I'd like to copy that data to another remote server's same table. 
  My problem is if I just execute the insert statement(which is very simple, uses static data just for testing) in a normal query, it succeeded; I can even select from the remote server.
  but when I put this simple insert into a trigger block: "unable to begin a distributed transaction"</p>
  
  <pre><code>CREATE TRIGGER T_SyrInserted
  ON [DBProba].[dbo].[Syr]
  AFTER INSERT
  AS BEGIN
  
  INSERT INTO [RemoteSrv].[DBProba].[dbo].[Syr] (SyrId, SyrNm ) VALUES (15000734, 'valami')
  END
  </code></pre>
  
  <p>Solved:</p>
  
  <ul>
  <li>Set the DTC authentication to None</li>
  <li>I run into an error "nested transaction cannot be executed because XACT_ABORT is OFF" so added a line before insert statement: SET XACT_ABORT ON; I dont know what "nested" I have done with an simple insert but fine...</li>
  </ul>