MSrepl_identity_range (Transact-SQL)

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

The name of the Publisher.

publisher_db

sysname

The name of the publication database.

tablename

sysname

The 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

The 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

The maximum boundary of the identity range.

threshold

int

The identity range threshold percentage.

current_max

bigint

The current max that can be assigned but not necessarily be assigned.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance