How to manually reuse the identity range under the merge replication


when you choose the auto manage the identity range on the merge replication, and some subscriptions dropped, that identity range could not reuse.

see this sample:

 

this sample used too large range for auto managed identity range. after some subscriptions dropped and recreated, the INT range used up:

Above highlighted Ranges in Green are currently used by the publisher and the subscriber.

However the rows which are not highlighted above, the respective subscription doesn’t exist and the ranges allocated are not being used (from 847061831  – 2147061831). This range is allocated to the subscriber which was failing