The simplest way to reset your identity fields is to use the 'truncate table tablename' command on the sql server. This will remove all records and reset the identity.

-Eric

>I'm having trouble figuring out how to reset an identity field's sequential count in a table, after I manually delete one or more records.
>
>As it is, when I delete the last record in a table, the next record I add adopts the next higher number, as though I hadn't deleted it at all.
>
>I tried changing the seed, but that didn't help, so I set it back to 1.
>
>TIA,
>Jeff