From: Michael Morton on
I'm using merge replication to get information to and from field
engineers, which has worked fine until recently.

Now, when any of the engineers try to replicate, the following error
occurs :

The Merge Agent failed because the schema of the article at the
Publisher does not match the schema of the article at the Subscriber.
This can occur when there are pending DDL changes waiting to be
applied at the Subscriber. Restart the Merge Agent to apply the DDL
changes and synchronize the subscription.
2010-04-22 08:27:35.844 Category:NULL
Source: Merge Replication Provider
Number: -2147199398

I have tried restarting the merge agent to produce a new snapshot and
have even got to the stage (yes, I'm that desperate) of reinitialising
all the subscriptions to try and prevent the error - to no avail.
Reinitialising works for a few syncs then it all falls over again.

For information, there have been no changes to the database structure
for about 2 months.

I've no idea where to look for more information so I could fix this,
as it's hurting our business, so any help would be greatly
appreciated.

Thanks.

Michael Morton

I REALLY have to learn how to post to newsnet
From: Michael Morton on
and I need to learn to spell usenet as well :-s