The TRUNCATE TABLE command will reset Identity column. If for some reason you cannot use it, take a look at DBCC CHECKIDENT in BOL.


>
>I have autonumber field, there is a delete all record process in my application, my question is simple how to reset the value of autonumber field back to 0.. I need advise .. thanks
>