Sunday, February 12, 2012

Are there any triggers added in transactional replication

As part of transactional replication, are there cases when triggers created
? I know custom sprocs are created in default trans repl and additional
column is created for updatable subscriptions.. but not too sure about
triggers ..
Hassan,
for immediate or queued updating subscribers in transactional replication,
you'll find triggers on the subscriber's replicated tables. These triggers
will either do a distributed transaction with the publisher, or insert into
the queue table.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment