Notes about Merge Replication

some usefull stored procedures you may use during merge replication;

* -

EXEC sp_adjustpublisheridentityrange @publication='Publication_Name'

//adjust identity range,if you get any error related with identity renge , you can reset identity offset managed by agent

* -

EXEC sp_helpmergearticle @publication='Publication_Name'

//retrieve article(s) information in given Publication_Name

* -

EXEC sp_changemergearticle @publication='Publication_Name', @article = 'Article_Name' ,

@Property = 'identityrangemanagementoption', //What would you like to do.ie disable identity management by agent

@Value = 'Manual',

@force_invalidate_snapshot = 0

//change article property ( http://msdn.microsoft.com/en-us/library/ms174386.aspx )