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

RE/
>Please, share your experience in using IDENTITY as PK . 

One advantage I see with using IDENTITY PKs (or any blind, dumb number...) is
that I'm protected against my own lack of knowledge.

For instance: I'd guess it's pretty easy to set up a "People" database on the
assumption that social security numbers are unique.   The long and short of it
is that they're not.  I almost made that mistake once, but my habit of using
surrogate keys whenever possible saved me from getting egg on my face when the
project was about 95% complete.
-- 
PeteCresswell