MSmerge_identity_range_allocations (Transact-SQL)
Applies to: 
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. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)