>One option, is to use the 'uniqueidentifier' field for your primary/foreign keys. You can then generate those keys without database involvement or worry that there will be a key conflict.
Lori,
Did you even read my replies? If not what is the intention of CCing to me?
Cetin