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

BINGO!  This is the point that seems to be missed by most every one.  Thank
you David

-- 
----------------------------------------------------------------------------
-----------
Louis Davidson ([EMAIL PROTECTED])
Compass Technology Management

Pro SQL Server 2000 Database Design
http://www.apress.com/book/bookDisplay.html?bID=266

Note: Please reply to the newsgroups only unless you are
interested in consulting services.  All other replies will be ignored :)

"David Portas" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Do you really allow the same Doctor, Department, etc to appear twice in
its
> table with different keys? If you don't declare unique natural keys then
> that's the kind of problem you have. An IDENTITY isn't a *surrogate* key
at
> all unless the table also has a natural key - it's just a physical row
> identifier.
>
> -- 
> David Portas
> ------------
> Please reply only to the newsgroup
> --
>
>