Error with Merge Replication

• Javier Carrascal

  Newbie

  Points: 2

  More actions

  February 28, 2005 at 9:12 am

  #166045

  Hi all ...I have the next problem. I´ve two publications in my developer server, both publications share a few tables. I configured the subscriptions from my local server. First, i synchronize one and later the other, when i synchronize the last, i obtain this error "The process cannot remove one or more tables, they are in use by other publications". This is like that ??? I cannot have both active subscriptions at the same time.

  Please, help me.

  regardsJavier

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  March 2, 2005 at 5:37 am

  #544830

  Are you sure theproblem appears when you synchronize the subscription ?

  Sounds to me more like the second subscritpion is trying to initialize.

  By default on initilization the tables are dropped and recreated on the subscriber and that would cause an error like yours.

  You can change this behaviour in the article properties or start synch without initialyzing.

  M

  [font="Verdana"]Markus Bohse[/font]

• Javier Carrascal

  Newbie

  Points: 2

  More actions

  March 2, 2005 at 6:09 am

  #544842

  Thanks for reply ...

  It has worked perfectly

   

  Now obtain this error ... The sequence of commands of scheme, it was not possible to spread the subscriber. !!

   

  I am fulfilling the suscripcion across a FTP.

   

  Regards