Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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)