Problem deleting rows on subscriber in transactional replication

  • 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 ...

  • 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,

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply