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?

C# Gnu
____________________________________________________

Excel Database Tasks : efficient business data processing
Version 3.3 released February 2015