Arithmetic overflow with IDENTITY INSERT option ON To work around this error, change the SQL Server data type of the IDENTITY column to a larger data type, such as BIGINT.

SQL Server Error Arithmetic overflow error converting IDENTITY to data type int The last insert will fail with the following message:Īrithmetic overflow error converting IDENTITY to data type int. To start, create the first test table and insert 3 different rows into it. Arithmetic overflow during a standard insertion Conclusion on IDENTITY arithmetic overflow 1.