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 |
|
mketron
Starting Member
4 Posts |
 Posted - 2007-06-20 : 11:21:05
|
| How would a build a trigger for this:I have a table (UOM) in one database (purchasing). I need it to update a table (xUOM) in another database (accounting) whenever it is updated.The whole table needs to be updated so they are the same in both databases. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-20 : 11:39:58
|
| Possible to use replication? |
 |
|
|
mketron
Starting Member
4 Posts |
Posted - 2007-06-21 : 13:44:06
|
| I do not want to use replication. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-06-21 : 13:55:16
|
| Why not just create a view in the accounting database that points to the UOM table in purchasing database? That way, the data is always the same.CODO ERGO SUM |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Trigger