Hello Mario, you'll have to use a query hint to achieve this behaviour. You
need a READUNCOMMITTED transaction isolation level.
Use this query from second client:
SELECT * FROM CUSTOMERS WITH(READUNCOMMITTED) WHERE CUSTOMERID = 'ALFKI'
But be aware that this way your second client might get wrong value if your
first client rollbacks transaction !
"Mario" <com.mx> wrote in message