This is not a new thing that just appeared on the web but a situation made me think to something I wasn’t giving enough attention until this morning!

If you manage some SQL Server database, do you know what the state of your identity fields in your SQL tables is? Continue to read on before getting this error:

Server: Msg 8115, Level 16, State 1, Line 1
Arithmetic overflow error converting IDENTITY to data type int.
Arithmetic overflow occurred.

I found somebody ( Narayana Vyas Kondreddi ) who wrote a nice little stored procedure that helps you check the state very quickly. Check http://vyaskn.tripod.com/sql_server_check_identity_columns.htm for the T-SQL code.