MSmerge_identity_range (Transact-SQL)

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.