C# Gnu (10/16/2012)
Your right !I did notice though that a select (ie select * from orders) hangs until the transaction commits or rolls back.
I can see that SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED allows the select statement to complete, but it then return rows that might be rolled back.
Is there a way of selecting only committed without the blocking effect?
Addition: so this in effect was my worry - that systems would be locked out while the transaction is open
C# Gnu
____________________________________________________