Calling SQL Server 2000 Experts - Can anyone provide inputs ?
Database
1
Posts
1
Posters
2
Views
1
Watching
-
I am trying to do the following ! 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