MSmerge_identity_range (Transact-SQL)

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

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.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)