Currently running merge replication on SQL Server 2008 10.0.1600 and having issues with adding and modifying triggers on published articles. I've searched through the MSDN site and googled it but have not found any definitive information on correct
We have a replicated table that had 1 trigger on it when it was added to the publication. That trigger was replicated. We have since added a 2nd trigger to the table and it is not being replicated to our other server. I've checked the Article
Properties and Copy User Triggers is set to TRUE. The only difference is the new trigger has NOT FOR REPLICATION in it, but I thought that would only keep it from being executed if a row is effected by the MERGE process.
We have rerun the snapshot and are syncing continuosly and the trigger does not replicate. Do I have to drop the tablefrom the publication and then re-add it? Am I missing something?
View Complete Post