MSmerge_identity_range (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

MSmerge_identity_range (Transact-SQL)

 

Applies To: SQL Server

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 nameData typeDescription
subiduniqueidentifierThe unique identification number for a given subscription.
artiduniqueidentifierThe unique identification number for the given article.
range_beginnumeric(38)The identity value at the start of the current range.
range_endnumeric(38)The identity value at the end of the current range.
next_range_beginnumeric(38)The identity value at the start of the next range to be assigned.
next_range_endnumeric(38)The identity value at the end of the next range to be assigned.
is_pub_rangebitA value of 1 if the identity range is assigned to the publication.
max_usednumeric(38)The maximum identity value that can be assigned.

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

Community Additions

ADD
Show:
© 2016 Microsoft