• Also remember that if you begin a transaction and rollback, the identity values will also have increased afterwards. That makes sense if you think about it.

    Identity is a count of attempted inserts, not consecutive sequential numbers. AFAIK you can't even really trust a sequence data type for that purpose either.

    You can do a DBCC CHECKIDENT(blah, RESEED) to reset it to the next available number though.