have learned to really dislike SQL Servers IDENTITY feature. (Those of us more familiar with Oracle, think of an IDENTITY column as a Sequence built into a table.)
In a hurry I tossed in dozens of IDENTITY columns, used em as FK’s all over as well, and then had to re populate a table…. Oh oh, now I remember why you don’t use IDENTITY with impunity!
Sigh…..
Back to the drawing (design) board. Being sloppy because I was in a hurry is no excuse, but now we get to pay the piper. (Must be a rich SOB by now!)
-Robert Porter