MSmerge_identity_range (Transact-SQL)
Applies to: 
SQL Server
The MSmerge_identity_range table is used to track the numeric ranges assigned to identity columns for subscription to publications on which replication is automatically managing these range assignments. This table is stored in the publication and subscription databases.
| Column name | Data type | Description |
|---|---|---|
| subid | uniqueidentifier | The unique identification number for a given subscription. |
| artid | uniqueidentifier | The unique identification number for the given article. |
| range_begin | numeric(38) | The identity value at the start of the current range. |
| range_end | numeric(38) | The identity value at the end of the current range. |
| next_range_begin | numeric(38) | The identity value at the start of the next range to be assigned. |
| next_range_end | numeric(38) | The identity value at the end of the next range to be assigned. |
| is_pub_range | bit | A value of 1 if the identity range is assigned to the publication. |
| max_used | numeric(38) | The maximum identity value that can be assigned. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for