identity column (int) overflow

kirankumarn

If identity column is of type 'int' we can address upto 2147483647 after that if we want to insert a new record it throws an exception

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

what is the alternate method for continuing the insertion of new records

ssnaik84

change data type to "bigint" :)

kirankumarn

if i use bigint than it stops at 9,223,372,036,854,775,807 after that if i insert record it gives error. My question is if identity column reaches max value than what next?

ssnaik84

if you are thinking in this way.. then GUID is only your solution..
but, its data type is string

kirankumarn

Thanks for your suggestion. It helped me really a lot.

ck9663

That's one big table. Try considering revising the design. You might be able to accommodate the creation of your PK, but the performance might suffer.

Just a thought.....

Happy Coding!!!

--- CK

identity column (int) overflow

re: identity column (int) overflow

re: identity column (int) overflow

re: identity column (int) overflow

re: identity column (int) overflow

re: identity column (int) overflow

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about