Problem deleting rows on subscriber in transactional replication

• hendrasd

  Old Hand

  Points: 353

  More actions

  February 6, 2004 at 3:04 am

  #101869

  I set up a transactional replication with updating subscriber. But when I tried to delete a certain rows on the subscriber, It produced the following error message : 'Updatable Subscriptions : Rows do not match between publisher and subscriber.....'. I wonder what would be the cause of the problem ? Any suggestions on how to workaround it ? Thanks in advance ...

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  February 8, 2004 at 6:21 pm

  #493206

  If rows do not match between Publisher and Subscriber then the Subscribers are most likely out of sync!

  Lets start from the beginning.

  (A) Did this error occur immediately after installing and configuring replication?

  (B) Were the subscribers dropped from the publication at any time? If so then thats most likely why they are out of sync!

  (C) how many subscribers are there? DOes this error occur on more than 1 subscriber?

  ---

  Kindest Regards,