Re: What are cons and pros for using IDENTITY property as PK in SQL SERVER 2000?

> Actually it's impossible to fix if you've deleted the original table since
> you no longer have the original ID numbers.

Hopefully you're not starting a DTS task, never mind dropping a table before
validating a successful transfer, without a decent backup in place.  I think
this is the kind of thing that Trey means when he uses the term
"avoidable"... I'll stretch it here to also mean "correctable."