IDENTITY Column Maximum Value

The maximum number of rows you can insert into a table depends on the precision that is set for the IDENTITY column.

If a table reaches that limit, you can either re-create the table with a larger precision or, if the table’s IDENTITY column is not used for referential integrity, use bcp to remove the gaps.

Related concepts
Maximum Value of the IDENTITY Column