We are implementing the Merge Replication on Sql Server 2000 with various MSDE PULL Subsriber.But here are the some of the common problems we are facing:
1. We are setting the Initial Snapshot for each subsriber and then doing the Subsequent subscription for them using the ActiveX in VB.The Replication works fine the same Day and it fails the Next day UNTIL we set the initial Snapshot again and do the Subsequent processes.
I guess the Snapshot job runs every night at 12:00..
2. Also what will happen if we try to add/Delete some new tables to the Publication database???Do we need to set the Replication again?