How to create a trigger to update data in another database
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!