Using IDENTITY and AutoNumber as PK defeats the purpose of PK, this
is not so bad in SQL Server as it allows you to choose something more
sensible if you have an IDENTITY field in use as PK.


When I wrote that it defeats the purpose of the PK it should have read it
defeats the purpose of clustering on the PK unless the creation order is the
one you want to physically order your records.

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
"Craig Alexander Morrison"
wrote in message ...