SQL Server Data Access
Setup a linked server on the server where youwant to place the trigger on and do your DMl operation on this using the syntax LinkedServer.database.objectname. As this is a distributed transaction you will need to have the MS DTC service running for providing concistency through the transaction.
HTH, Jens K. Suessmeyer.
Do you need to execute the command on the linked server synchronously
HTH, Jens K. Suessmeyer.
The scenario you described is actually synchronously, in addition if the Update trigger fails, the whole transaction will be rolled back (which you probably donˇŻt want). i would suggest using a table where you write the reference to the updated data on the table in S1. check this table in small intervals via a SQL Job and update the s2 server then.
HTH, Jens K. Suessmeyer.