Is there anything like NO LOCK option in sybase SQL server10.0.3.
The SELECT stmt (even without holdlock, isolation level=1,
unchained tran mode) momentarily acquires shared lock on the page
that is being read/selected (Sh_page). This sometime conflicts
with a long (4 mins, not too long I guess) running transaction
(updates) and causes deadlock. Is there any way where we can force
a SELECT stmt to retrieve records without any lock. It is ok even
if the data is dirty.
Following is the scenario of the tran execution:
User 1 User 2
Update ... (locks pg 1)
Select ... (waiting to lock pg 1)
What I really want is the "select..." by User 2
should not acquire any locks.
I appreciate any help in this re:
Shami Palanivelu ;
University of NorthDakota ; 701-777-2151 (Phone)
Grandforks, ND - 58202 ; 701-777-2940 (Fax)