Hey all,

I wonder if it is possible to reset the seed of an identity.
What I want is the following:

Mytable has an identity MyIdentity with seed and increment 1. Records are added. Then the last record is deleted. Is it possible to have MyIdentity of the next new line following the one of the last non deleted line ? (I hope I'm making myself clear).

Greetz,
Hans