>Hi Kevin
>
>I have not looked into REPEATABLE READ, but certainly will.
>
>Thanks for the heads up
You might also want to look at Sergey's suggestion about sequence objects, which were introduced in SQL 2012. If you're looking to generate identity values across many tables, the sequence object can do that for you.