Hello,

I am new to creating a trigger in sql server so I need your help.

I have 2 sites, 2 databases (same name) on 2 different servers, S1 & S2. These database are the same name, tables, data, 100% the same.

I am using ASP to code. Currently, I have to enter data for each website, which is 2 times.

How can I create a trigger so that everytime there is an update in database in Server1, then the database in Server2 gets updated.

Thank you very much!