Posted by Roy Harvey on 06/27/07 19:57

On Wed, 27 Jun 2007 19:40:12 -0000, Weyus <weyus@att.net> wrote:

>It looks like if I do a
>
>SELECT blah FROM TABLE WITH (TABLOCK XLOCK)
>
>at the very beginning of my transaction, that would do the trick
>right?
>
>Wes

If you plan on locking the entire table during the load, why not just
let the IDENTITY value be assigned normally? It seems like you are
creating a load of extra work for yourself.

Roy Harvey
Beacon Falls, CT

[Back to original message]