We are running 2 Microsoft SQL Servers - publisher (2008R2) / subscriber (2008 Express) with merge replication.
I tried to make some schema changes via Transact-SQL and partly failed. So tried to drop the offending table from the publication to make the changes but since then I keep getting this error:
The replication Merge Agent failed to propagate a Publisher schema change to the Subscriber.
I have tried reinitialising the subscription with a new snapshot and failed. I have upgraded both SQL Servers to the latest service pack. I used this to get outstanding schema changes:
EXEC sp_enumeratependingschemachanges @publication = 'xxx_Publication'
then used this to skip the outstanding schema change:
EXEC sp_markpendingschemachange @publication = 'xxx_Publication', @schemaversion = 1554, @status = 'skipped'
and it has gone from
Then did new snapshot/reinitialisation but still getting the same error message!
Please can someone advise? Meanwhile there have been changes to both DBs that need to be synced back together.