>If I will delete all records from the table and after it I will insert new record I will get Identity field = max + 1, but not 1...
>Why? And how to force SQL server to count Identity field from 1 again.
>
>Giedrius
I think you can use:
DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
to reset the Identity value for a table.
Chris McCandless
Red Sky Software