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 |
|
benoityip
Starting Member
14 Posts |
 Posted - 2003-08-31 : 23:13:56
|
| Server A --company HQ--subscriberServer B,C --company branch, publisherEeverynight, B and C pushes new order and customer information to the HQ, it is impossible for conflict to occur becasue we use GUID as the identifier for customer and order table....However, when adding new order, the inventory needs to decrement the quantity of the products once new orders are inserted...Could that be implmented using transactional replication? Is there a way that I can use customer store procedure instead of trigger to implement the inventory decrement process?Thanks |
|
|
|
|
|
Transactional Replication