MSsub_identity_range (Transact-SQL)
Applies to: SQL Server
The MSsub_identity_range table provides identity range management support for subscriptions. This table is stored in the subscription databases.
Column name | Data type | Description |
---|---|---|
objid | int | The ID of the table that has the identity column being managed by replication. |
range | bigint | Controls the range size of the consecutive identity values that would be assigned at the Subscriber in an adjustment. |
last_seed | bigint | The lower bound of the current range. |
threshold | int | The percentage value that controls when the Distribution Agent assigns a new identity range. When the percentage of values specified in threshold is used, the Distribution Agent creates a new identity range. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for