Re: Should "begin tran" hurt like this?

#1

On Mon, 08 May 2006 11:07:26 +0200, "Steen Persson (DK)"
<spe (AT) REMOVEdatea (DOT) dk> wrote:

Quote:

Have you tried to use the NOLOCK hint in your NOT IN (SELECT .....)
part? I think that when you use BEGIN TRAN then it locks MYTABLE and
then your select statement will wait forever.

But it runs fine from QA.

Hmm, that defaults to read committed, but it doesn't lock out
self-made changes, never did before, anyway, and looks OK even now.

BUT, do packages run by default as read committed, when run under DTS?

Thanks.

Josh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Should "begin tran" hurt like this?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Should "begin tran" hurt like this? - 05-08-2006 , 01:19 PM