>Hi steve,
>
>Not the whole key table has to be locked if you're sure that concurrent insertions of new keys cannot occur. IOW, if the possible keys are already in the keys table, a record lock will do perfectly.

Right you are, of course.

I've seen many NewId() procedures and many of them used implicit locks. I'd happily use an autoincrementing default value that's guaranteed to be unique even in high speed insert situations...

**--** Steve