Transact-SQL Reference

MSrepl_identity_range

The MSrepl_identity_range table provides identity range management support. This table is stored in the publication, distribution and subscription databases

Column name Data type Description
publisher sysname Name of the Publisher.
publisher_db sysname Name of the publication database.
tablename sysname Name of the table.
identity_support int Specifies if automatic identity range handling is enabled. 0 specifies that automatic identity range handling is not enabled.
next_seed bigint If automatic identity range is enabled, indicates the starting point of the next range.
pub_range bigint Publisher identity range size.
range bigint The size of the consecutive identity values that would be assigned to subscribers in an adjustment.
max_identity bigint Maximum boundary of the identity range.
threshold int Identity range threshold percentage.
current_max bigint Current max that can be assigned but not necessarily be assigned.