Merge Replication

• theauketts

  Newbie

  Points: 5

  More actions

  August 20, 2008 at 9:08 am

  #96381

  We have a system that uses merge replication over FTP (ADSL) to keep a web based application up to date. We have been having problems with random missing rows which we have tracked down to an error which is occurring during merge.

  It appears as though inserts at the subscriber fail with a foreign key constraint error and this then causes the rows to be deleted at the publisher.

  Publisher is SQL2000 Standard SP4

  Subscriber is SQL2000 Enterprise SP3

  Our problem looks like this issue http://support.microsoft.com/kb/326483 but service packing does not match.

  Any help appreciated.

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  September 3, 2008 at 2:00 pm

  #866793

  So your FK constraints are failing the inserts and therefore rolling back the insert on the publisher.

  Have you though of making your FKs on the subscriber NOT FOR REPLICATION?

  Graeme