Question about IDENTITY

Just a quick question.

I have a table with an IDENTITY field. I inserted a record using the is 1024 so as to distinguish the record. There are only about 40 records in the table, including id 1024.

What I need is for the IDENTITY to go back to 39 and start it's count from there to fill the gap up to 1024. How is this done?

Delete the record with id 1024 then edit the table and set the "Identity Seed" to 39. You could probably write an alter table statement to handle this or go into enterprise manager and design the table.

Why can't the ID's continue after 1024? Other than looks it shouldn't matter as long as the ID's are unique.

-- LZ

|||

True. It doesn't matter, the IDs are unique, and 1024 serves it purpose...
For the most part, I am just trying to get a better handle on IDENTITY and the various ways to control it.

I only have access to the database through code (and a form that I hid on the server that allows me to insert SQL statements), and I am just trying to make sure I have as much control over the data as I would if I had direct access to it.

Thanks for your input...