turning of user trigger replication

• ndpace

  SSC Enthusiast

  Points: 152

  More actions

  September 20, 2011 at 12:56 pm

  #244031

  I have a SQL2008 with merge replication setup. I do not want to drop replication but I need to edit some existing triggers, and the triggers are different for each server.

  Can I go into the publication and into the table article and change “copy user triggers” from true to false without messing up replication?

  If so are there any other steps needed? Do I need to do anything with the snapshot?

  Will this make it so I do not get errors when trying to alter the trigger at a subscriber?

  Thanks in advance, Jim

• ndpace

  SSC Enthusiast

  Points: 152

  More actions

  September 23, 2011 at 6:10 pm

  #1386072

  can anyone help me with this? I have to get things fixed this weekend and need to know how to do this.

  Thanks in advance, Jim