Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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.