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 disable identity management by agent
@Value = 'Manual',
@force_invalidate_snapshot = 0

//change article property ( )


Popular posts from this blog

Assembly Microsoft.Dynamics.Service.Plugins.dll can not be loaded. Dynamics CRM 365 Engine version 9 - CRM User creation error

Exception caught instantiating TERADATA report server extension SQL Reporting Services

Could not load file or assembly 'System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified at Configuration class initiation in