Schema Change (Add Table on Merge Publication) Every time the merge agent runs (pull subscription), the schema changes are again applied to the subscriber

• Eduardo Bermejo Olvera

  Grasshopper

  Points: 19

  More actions

  September 30, 2009 at 1:12 pm

  #211604

  Hello,

  I have the following problem:

  I have added a new article (table) to a merge publication on SQL 2005.

  For some reason, every time the merge agent runs (pull subscription), the schema changes are again applied to the subscribers.

  This does not happen with the subscribers with reinitialized subscriptions.

  However if possible I would like to avoid reinitialization.

  What can I do to apply the schema changes only once?

  Thanks in advance.

  Ed