Currently running merge replication on SQL Server 2008 10.0.1600 and I have a few questions around the correct procedures for adding and modifying triggers on published articles. I've searched through the MSDN site and googled this but have
not found any definitive information on correct procecdures.
1) When a new trigger is added to a published table do we just have to rerun the snapshot and then re-syncy the subscribers? Just adding them does not seem to replicate them to subscribers.
2) When an existing trigger is modified should ALTER TRIGGER be used or should the trigger be dropped and then re-added?
View Complete Post