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

I've read through this thread but I don't understand it.  I always use an
int or smallint as primary key, with identity.  I believe it would be a mess
otherwise.

Example: I have a table with people, last name, first name, address, ...  So
suppose you would make a natural key then you need at least the last name
and the first name.  I have >25 other tables that reference that table.  If
I get this right I will need to use the name and firstname field in all the
other tables as well to reference.  Isn't that just a lot of data waste?  If
I'm missing something, please tell me what because this seems a bit silly.


Stijn Verrept.