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

• Next in forum: Re: How to make a SQL run longer?
• Prev in forum: Re: How to make a SQL run longer?
• Thread view: Re: How to reliably ensure that only one set of rows is bulk imported into a table at a time

[Reply to this message]