Home / server / Questions / 226105
Accepted
Timofey
Asked: 2011-01-25 02:40:50 +0800 CST

SQL Server 2008: what happened if identity oversteps a maximal value of int?

  • 772

Imagine we have a table:

create table MYTABLE (
 id int IDENTITY(1,1)
,name varchar(10)
)

We have to insert a lot of rows into the table.

Does anybody know what will happen when a generated identity value oversteps a maximal integer value (2^32-1)?

sql-server sql-server-2008 identity-management

1 Answers

  1. Best Answer

    1. You will get the following error:

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

    2. You won't be able to insert more records, until you:

    • 4