This stored procedure is used to update identity range assignments. It ensures that automatic identity range management functions properly after a Publisher has been restored from a backup. This stored procedure is executed at the Publisher on the publication database.
sp_restoremergeidentityrange is used with merge replication.
sp_restoremergeidentityrange gets maximum identity range allocation information from the Distributor and updates values in the max_used column of MSmerge_identity_range_allocations (Transact-SQL) for the articles which use automatic identity range management.