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