Help, please. At me such problem.
I work in VB 6.0. I in a sql-server 2000 have a table with column NUM with parametres:
Allow Nulls - No
Data Type - int
Identity Specification - Yes
Identity Increment - 1
Identity Seed - 1
Indexable - Yes
At addition of new record column NUM should be filled automatically. I have added 10 records, column NUM was automatically filled with 1 on 10. But, as soon as I have removed all of them, and have started to add records, value NUM became 11 and above. And it is necessary to me that value was from that record, which goes next after removal (in my example if to remove all records, value NUM should begin with 1, if to remove to 5 records - that value following should be 6, etc.) In what a problem? How to solve this problem?