GilaMonster (1/19/2009)

---

That'll happen any time an insert doesn't succeed (due to a constraint violation, a datatype conversion error or a trigger rollback) or when rows are deleted. The id will be assigned as the insert starts, and the current identity seed incremented. If the insert doesn't succeed, the identity seed is not decremented again (there may already have been another insert)

It's normal with an identity column