Home Forums SQL Server 7,2000 T-SQL alternative to nolock to avoid blocking trans RE: alternative to nolock to avoid blocking trans
GRN
Hall of Fame
Points: 3260
More actions
June 7, 2003 at 2:03 am
#460281
coverston
you want the select to honor locks - but you want to read the locked data?? - that seems like a bit of contradiction to me .. In case i've got you wrong - would READPAST help - this would just skip the locked rows???