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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-22 : 10:16:36
|
| Navinderjit writes "Hi,We have 3 MS SQL 2005 DB on separate machines but on same network. Now we need to write a TRIGGER on the first two DB so that on each insert/update it INSERT/Update the same on the third DB. Is is possible to use trigger to update records on separate DB located on separate server?If yes, how?All 3 DB are on separate machines, but on the same network and of same machine specifications and configuration." |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-09-22 : 10:46:30
|
| It might be possible to do, but it is a really bad idea.You should look into replication to do this,CODO ERGO SUM |
 |
|
|
|
|
|
Using trigger to update DB across server