Bogus rows in MSsubscription_articles

• Andy Stephenson-354717

  SSC Journeyman

  Points: 94

  More actions

  March 23, 2011 at 5:13 am

  #100361

  Hi - we use SQL Server 2000 transactional replication with queued updating. The problem I'm having is that MSsubscription_articles has multiple rows in a single article, one row with the corrrect artId, the other an incorrect, smaller artId. When queuereader picks up rows to go back to the publisher, the row has the wrong artId, to the action fails.

  When I take the publication out of replication, one row left in the table. How can I clean up the subscriber?

  Andy

• Graeme100

  SSCertifiable

  Points: 7925

  More actions

  July 5, 2011 at 5:17 am

  #1348186

  Have you checked how the multiple rows are being generated.

  Look at the replication tables on the subscriber and test what happens when you make a change to a record.

  Graeme