CREATE TRIGGER [TESTE] ON [TABELA_XYZ]
   AFTER INSERT
AS
BEGIN
  INSERT INTO LINKSERVER.BD.DBO.TABELA_ABC (CAMPO1, CAMPO2)
  SELECT CAMPOA, CAMPOB FROM INSERTED
END

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