| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSmerge_identity_range (Transact-SQL) |
MSmerge_identity_range (Transact-SQL) |
VanMSFT |
vanto |
03/04/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE 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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)