identity reservation size

identity reservation size sets a limit for the number of identity values.

Summary Information

Default value

1

Range of values

1–2147483647

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

SQL Server Administration