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.

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