You can use DBCC CHECKIDENT() to reset the next identity to a new value. Why do you want to do this after deleting a row?
-Mike
>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