Merge Subscription Snapshot Fail: Invalid Object Name 'sysmergeschemachange'

[Hagesfeld]

I am trying to set up a merge subscription between two servers. They
had a merge subscription, and it stopped working inplexicably. In
trying to remove the prior subscriptions and re-enable replication, I
removed all the replication tables and stored procedures and recreated
them. I have also disabled and re-enabled replication on the
subscription server multiple times.

The error I get is "Invalid object name 'sysmergeschemachange'" (error
# 208). This causes "Process could not deliver the snapshot to the
Subscriber." I have tried dropping and re-adding the
sysmergeschemachange table on the subscriber, without luck.

Any ideas?

[Kevin Nicholas]

If possible, look at the order the snapshot files are attempting to be
applied to the Subscriber. The file order may need to be manually tweaked if
they are being applied in an inappropriate order e.g. another database object
needs to exist first.

This article may be relevant
http://www.replicationanswers.com/AlterSchema2005.asp

[Paul Ibison]

When you removed the replication, did you drop the distributor and run
sp_removedbreplication on each replicated database. If not, and it is
possible right now, I'd do it this way. After that you can script in the
publication as per usual.
HTH,
Paul Ibison