November 19, 2020 at 9:15 am
I am new to merge replication and setup merge replication and using automatically manage identity. There was insert failed error
"It conflicted with an identity range check contrait in database XXX replicated table T_Mytable column Id . If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber run the Distribution Agent or the Merge Agent"
I manually run sp_adjustpublisheridentityrange and it fixed the insert issues. After that found out that the index has jump from 279184 to 301189 in the table T_Mytable. It means there are 22005 been allotted to subscribers.
I have changed Publiser range size 300000 and Subscriber range size 100
Basically Subscribers will not be inserting on table T_Mytable but only updating rows. How can I get back the indexes(22005 ) allotted to subscribers. What is the best practice in this case
November 20, 2020 at 10:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply