Couple of Replication trigger Q's

This is all just theory for now - as we haven't yet begun to use Replication, but some questions have come up early in the design phase.

1) Does replication fire triggers on the destination table in the destination db ?

2) Are rows replicated one by one and each one fires the triggers, what happens with batch inserts ?

Who is Participating?
danblakeConnect With a Mentor Commented:
1) It can be made to fire triggers in the destination db if data is replicated to the destination db.
(Most replication types create triggers on the destination tables and would normally not require all triggers at all sites)

2) Batch size is controlled by the distribution agent.
(It can be set to fire one row by row, but normally updates are sent as batchs, which depends on how you setup the system..)

Any update ?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.