GilaMonster (10/16/2012)
C# Gnu (10/16/2012)
Addition: so this in effect was my worry - that systems would be locked out while the transaction is openIf they try to read rows that are locked, they have to wait until the locks are released.
Hmm, Seems like an option is missing to me!
BEGIN TRANSACTION NOBLOCK
I would have thought the default 'ISOLATION LEVEL COMMITED' select statement should return all committed rows and ignore any uncommitted rows - rather than wait forever.
C# Gnu
____________________________________________________