S
spring
We have a table with an autonumber field which now ranges from 1 to 10000,
somehow the autonumber jumped back to 7000. therefore new records cannot be
added because of key violation.
I temporarily solved this problem by inserting 3000 new records and then
delete.
(above numbers are just for easy explanation)
It happened twice and i want to know how could it happen or how to prevent?
Thanks in advance!
somehow the autonumber jumped back to 7000. therefore new records cannot be
added because of key violation.
I temporarily solved this problem by inserting 3000 new records and then
delete.
(above numbers are just for easy explanation)
It happened twice and i want to know how could it happen or how to prevent?
Thanks in advance!