By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

identity column (int) overflow

P: 31
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
Oct 13 '09 #1
Share this Question
Share on Google+
5 Replies

P: 149
change data type to "bigint" :)
Oct 13 '09 #2

P: 31
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?
Oct 13 '09 #3

P: 149
if you are thinking in this way.. then GUID is only your solution..
but, its data type is string
Oct 13 '09 #4

P: 31
Thanks for your suggestion. It helped me really a lot.
Oct 14 '09 #5

Expert 2.5K+
P: 2,878
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
Oct 14 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.