|
The integer (int)
IDENTITY insert will give an "arithmetic overflow" exception
when reaches the limit of 2,147,483,648.
To recover change
the IDENTITY column type from int (4 bytes) to bigint (8 bytes) or GUID(uniqueidentifier) (16 bytes).
Another solution is to RESEED it into the negative integer range.
Related articles:
int, bigint, smallint, and tinyint (Transact-SQL)
http://www.sqlusa.com/bestpractices/reseedidentity/
|
