sql server replication: Merge replication with summary tables that are affected by trigger -- sql server replication

Merge replication with summary tables that are affected by trigger

mspradley
12/19/2004 11:09:01 AM

sql server replication:

How does merge replication work when you have a summary table that is
affected by triggers?

For example: a chart of accounts table that has balance information updated
from triggers on a transaction table.

Merge replication with summary tables that are affected by trigger

Paul Ibison
12/20/2004 1:08:33 AM

As long as the triggers have not been created witht eh
not for replication attribute, they'll fire. The general
recommendation is to not have triggers firing on the
publisher and the same triggers doing he same work on teh
subscribers - what is recommended is to have the triggers
fire on the publisher and the table that is written to is
also replicated itself.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)