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|
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.