I'm just preparing some teaching material on Merge replication and it would be really helpful if anyone has a story concerning generation numbers in the msmerge_contents or msmerge_genhistory tables. Have you ever changed them? What were the reasons and effects of changing them? sp_mergecleanupmetadata as I understand removes all the entries and I'm not so concerned with that, but I have definitely heard of someone changing generation numbers directly to affect a change - any ideas.
Thanks in advance.
Paul Ibison
Paul.Ibison@blueyonder.co.uk
Paul Ibison
Paul.Ibison@replicationanswers.com