| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSmerge_identity_range_allocations (Transact-SQL) |
MSmerge_identity_range_allocations (Transact-SQL) |
VanMSFT |
vanto |
03/04/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
The MSmerge_identity_range_allocations table is used to track the history of identity range assignments, to both Publishers and Subscribers, for published articles. This table is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
| publisher_id | smallint | The ID of the Publisher. |
| publisher_db | nvarchar(128) | The name of the publication database. |
| publication | nvarchar(128) | The name of the publication. |
| article | nvarchar(128) | The name of the article. |
| subscriber | nvarchar(128) | The name of the Subscriber. |
| subscriber_db | nvarchar(128) | The name of the subscription database. |
| is_pub_range | bit | Lists whether the identity range is assigned to a Publisher. |
| ranges_allocated | tinyint | The number of identity ranges assigned. |
| range_begin | numeric(38) | The starting value of the range. |
| range_end | numeric(38) | The last value in the range. |
| next_range_begin | numeric(38) | The starting value of the next range to be assigned. |
| next_range_end | numeric(38) | The last value of the next range to be assigned. |
| max_used | numeric(38) | The highest identity value used. |
| time_of_allocation | datetime | The time when the assignment was made. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)