easy ...truncate resets the identity;
It's a coincidence , I was just discussing it with my colleague about inserting a row in between identity inserted column. And yes, Truncate popped up as an option 🙂
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: