Jeez, this sure has generated a lot of messages.....
My take: I'm with the surrogate key crowd. I don't reuse crap. I either use some variation on SYS(0)+SYS(2015) or a GUID and fuggedaboudit.
Even SQL Server is going this way, hence the uniqueidentifier (which is a GUID) in addition to the identity (integer).
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
