Chris,

Thanks for the reply. I can do what you suggest and everything will work fine. My problem is I deleted over 20,000 records from two tables in the publisher. 6 records were not deleted in one table and 18 in the other. Any subsequent transactions have been fine. I'm trying to find out why these 24 records were not deleted as they should have been.

It was a pretty simple test - I loaded a bunch of data on my publisher, watched it replicate in the monitor and ran the Redgate compare tool to check that it worked. Everything was fine at this point. I then deleted the test data from the publisher, ran the compare tool again and it showed up these 24 records in the subscriber.

I should point out also that both the publisher and the subscriber were connected to the network during this test. The subscriber however is in a different site, over 100 miles away. I'm beginning to wonder did something happen on the network - dropped packets maybe??

Either way, I can't really conclude that merge replication is a reliable approach for my solution after this test.