Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Orphaned records at subscriber after replication

Author  Topic  Russ220 Starting Member 1 Post Posted - 2005-06-21 : 10:28:16 Using SQL Server 2000 (SP4) on the Publisher, and MSDE on a subscriber, I'm experiencing orphaned records at the subscriber after running a merge publication in replication. Two tables (a header and detail table) have a one to many relationship. Using a row filter, header records flagged with a bit value of "0" (for incomplete) should remain on the subscriber (as well as the detail records) until they're flagged with a "1" (complete). The row filter is on the header table only and a join is used for the detail records. After running the merge publication, any completed headers and their corresponding detail records are successfully replicated to the publisher, the headers are deleted at the subscriber, but the detail records remain on the subscriber, which is a problem. It had been working fine in the past. Encountered this issue a while back, and removing and rebuilding replication resolved it. I've again removed and reinstalled replication, and it didn't fix it. I deleted and rebuilt the databases at the publisher and subscriber, and then rebuilt replication - it still didn't fix it. I checked the nickname column in sysmergearticles, and the detail table has a lower number, which from what I understand, means that it will process changes in this table first, before the header. Any idea why these records remain at the subscriber?! Any insight would be appreciated.