Posts

Showing posts with the label Merge Replication

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 )