Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
prettyjenny
Yak Posting Veteran
57 Posts |
Posted - 2013-05-16 : 09:27:52
|
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! |
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-05-16 : 10:34:07
|
Refer to this:http://stackoverflow.com/questions/592280/trigger-to-update-data-on-another-sql-server |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-17 : 00:05:22
|
why not simply apply replication if attempt is to keep both databae objects in sync?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-05-17 : 01:55:15
|
Triggers utilised in this style - could cause all sorts of problems. The most obvious one being integrity of data\troubleshooting . Couldn't you operate 1 database server? ,Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
Ifor
Aged Yak Warrior
700 Posts |
|
|
|
|