Graig,

>As Larry said, you should not reuse primary keys. There is a KB article on my web site that discusses this and provides code to generate new PKs.

As Walter says, you should watch out with these kind of statements. This person might have a circumstance where generated PKs are only complicating things. There is NO uniform statement in the DB world that you should use generated PKs in all cases. Please read "Joe Celko's' articles.

Walter,