Hello Everyone, Does anyone know if there is anyway to reset an AutoNumber field in a table on SQL server? Sort of the same way it would reset in a local table when you Compact and Repair the database.
Might want to run a MAX(ID) to get the last autonumber.
Or delete the records you don't want and get the next number you want manually to use in the above.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
SQL Forum.
