>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.