Identity Column Nearing Or Reached Max

Identity columns are auto-assigned values by SQL Server and have a maximum value determined by the column type (see table below). Each time a row is inserted into the table, the identity column is assigned the next highest value. If the identity reaches the maximum value, inserts will fail.

Column Type Maximum Value
tinyint 255
smallint 32767
int 2147483647
bigint 9223372036854775807

Suggested Action

If further inserts into the table will be expected, then consider changing the column type to the next largest type (e.g., int → bigint).

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.