Arithmetic overflow error converting IDENTITY to data type smallint. Arithmetic overflow occurred.

ERROR MESAGGE:

“Arithmetic overflow error converting IDENTITY to data type smallint. Arithmetic overflow occurred.”

EXPLANATION:

You may experience this error when you try to insert a row into a table that contains a column that has the IDENTITY property, and the data type is smallint.

The upper limit of the smallint data type is 32,767. (costs 2 Bytes) You cannot add more records after reaching this value.

SOLUTION:

If you want to insert more rows into the table, you can use the Integer data type instead of smallint. The upper limit of the Integer data type is 2,147,483,647. The cost is 4 bytes.