Check out the BOL(Books On Line) fro the topic
"Use generic syntax for finding gaps in identity values" for detailed examples of how to find gaps.
>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