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

"Trey Walpole" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> > And what happens if someone does a DBCC checkident ('FOO', RESEED)?
> >
> > Or you have to copy it into a new table and accidently set that table up
> > with an IDENTITY column and now all your rows get new IDs?
>
> Fire the DBA. If they've allowed unskilled people such access or do
anything
> accidentally, no telling what other problems they'll cause ;)

Pray your employer never employs the same standard.