Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
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
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)