SQL Server Experts !

[ManaInfy]

I am trying to do the following ! ( SQL Server 2000 ) Open one session of Query Analyser Window Begin Trans Update Table1 Set ... But I don't commit ! Open another session of Query Analyser Window Select from Table1 Select gets Blocked unless Update is committed ! CAN'T I DO A SELECT WHEN UPDATES/INSERTS Occur ? I Can do with NOLOCK but we don't want uncommitted data to appear ! I have tried with all transaction isolation levels. Anyone can help ? Thanks Anand

[jkgh]

Just think about what a transaction is designed to do. eternal student Give a man a fish and you feed him for a day; teach him to use the 'net and he won't bother you for weeks.