AutoNumber field limit
Database
3
Posts
3
Posters
0
Views
1
Watching
-
What is an AutoNumber field's maximum limit? What happens when the maximum limit is reached?
-
What is an AutoNumber field's maximum limit? What happens when the maximum limit is reached?
Its the limit of a long interger, roughly 2 billion. I would be interested to know what happens when it hits the max too :)
-
Its the limit of a long interger, roughly 2 billion. I would be interested to know what happens when it hits the max too :)
You get an error :
Server: Msg 8115, Level 16, State 1, Line 1 Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occurred.