Merge Replication -- Bad Insert trigger

I have bad insert trigger created on the publish. It is trying replication this trigger to the subscriber but it is getting a syntax error. It has now been corrected on the publisher but the subscriber will not get passed the bad ddl change of the orginial trigger. How do I tell merge replication to ignore this bad version of the insert trigger.

Re-initializing is not an option.

June 26th, 2015 9:00pm

we have skip error option on replication, how ever this we need to analyze before using it.

As per the description of the problem it seems there was a issue with the trigger syntax and which is got corrected on publisher. If schema changes is enabled on the publisher it will automatically publish the corrected one till that time the replication monitor will through the error.

If you have script in handy execute that on subscriber too.

Hope I understood the problem because question is not so clear on the part "It has now been corrected on the publisher but the subscriber will not get passed the bad ddl change of the orginial trigger. "


Free Windows Admin Tool Kit Click here and download it now
June 26th, 2015 10:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics