msrepl-identity-range-transact-sql.md

title	MSrepl_identity_range (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/04/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSrepl_identity_range_TSQL MSrepl_identity_range
dev_langs	TSQL
helpviewer_keywords	MSrepl_identity_range system table
ms.assetid	6e92a8e8-7667-4c98-b1c4-46735bac50d8
author	stevestein
ms.author	sstein

MSrepl_identity_range (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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)