Unanswered: Merge Replication - Delete Records From Subscriber After Synchronizing
I am using merge replication between one publisher and one subscriber. My publisher has SQL 2000 Enterprise w/SP 3a. My subscriber has SQL 2000 Personal w/SP 3a. The subscriber has a pull subscription that is only run on demand. There is a static filter on the publication and the article is set to drop the existing table and recreate it.
Half of my merge is working OK...new records on the subscriber are being added to the publisher and updated records are updated just fine. However, after synchronization occurs, updated records are deleted from the subscriber, but records that were inserted into the publisher remain. I want both inserted and updated records to be deleted from the subscriber. The inserted records would not meet the filter criteria on my publication so I don't understand why they are not deleted. How do I delete the records from the subscriber after they have been inserted into the publisher?