MSmerge_identity_range_allocations (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)