I was getting the error: "Arithmetic overflow error converting IDENTITY to data type int", when inserting a record in a table with a identity column. The max id of this table was 45448, this is certainly not the max of int in SQL Server, so I expected the next Id to be 45449, but DBCC CHECKIDENT returned 2147483647 (the max of an int). 

DBCC CHECKIDENT ('Reporting.MyTable');

Reseeding the table with DBCC CHECKIDENT fixed the problem:

DBCC CHECKIDENT ('Reporting.MyTable', reseed, 45449)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.