>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 believe if you do a TRUNCATE TABLE the identity will go back to the original seed.

BOb