Hi. I am using an auto increment index in a db in sql server 7. The problem is, that when a record is deleted, it leaves a "hole" in the index count. For example, lets say that there are 10 records and we delete record 7, and we then add a record, the record gets added with index 11 instead of 10. This is due to the
"hole" that was created when we deleted. Now imagine if there are thousands of records and there was considerable deleting going on. There would be "holes" all over the place. This is unwanted. Can anyone help me solve this problem with the index. pls