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)