MSmerge_identity_range_allocations (Transact-SQL)
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
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables