Lynn i have created this in new thread
Hi Gail and other experts
How does "ROWLOCK" work? I have this situation:
User1 - Query Analyzer
update t1 with (rowlock) set c1 = 10 where c1 = 5
User 2 - Query Analyzer
update t1 with (rowlock) set c1 = 20 where c1 = 15
Since the query executed by User1 is done with begin transaction the which User2 fires fails to execute until I do rollback or commit transaction in User1 - Query Analyzer.
According to me SQL Server should only do Row Level locking and should allow the other query to execute, but it does not execute. Can you please explain to me why?