Unanswered: Arithmetic overflow error converting IDENTITY to data type int
I have a table with an INT primary key (SQL Server 2000).
The table has been truncated (so no rows of data and, I believe, the identity seed reset).
I then attempt to add a SINGLE row and get the following error message:
Server: Msg 8115, Level 16, State 1, Line 1
Arithmetic overflow error converting IDENTITY to data type int.
Arithmetic overflow occurred.
This table has existed in the schema for about 4 years, and is truncated nightly and multiple rows inserted successfully.
I have used SQL Server's analysis tools [DBCC CHECKTABLE (tableName),
DBCC CHECKALLOC, DBCC SHOWCONTIG and sp_help (tableName)] and they all indicate that the table has no underlying problems.
I scripted the table and created a clone (slightly different name) and successfully added my single row to that table.
So...something is wrong with this table. But what? Obviously I could drop the table and re-create it, but I'd first like to understand what's gone wrong with it just in case there's something fundamentally wrong.