Cross-server write trigger

Create trigger t_test on Test
For insert, update, delete
As
Set? Xact_abort on
-- Start the MSDTC Service of the remote server
Exec master .. xp_mongoshell 'isql/s "xz"/u "sa"/P ""/Q "Exec master .. xp_cmdshell ''net start MSDTC '', no_output" ', no_output

-- Start the MSDTC Service of the Local Machine
Exec master.. xp_mongoshell 'net start MSDTC ', no_output

-- Performs distributed transaction processing. If the table uses the ID column as the primary key, use the following method:
Begin Distributed Transaction
Delete from OpenRowSet ('sqloledb', 'xz '; 'sa'; '', test. DBO. Test)
Where ID in (select ID from deleted)
Insert into OpenRowSet ('sqloledb', 'xz '; 'sa'; '', test. DBO. Test)
Select * From inserted
Commit tran
Go