Reading a locked row

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Is there a way to lock rows for bulk updates yet still have other
processes read the state of the rows prior to the lock without waiting
until the bulk update commits? Note, I am using SqlTransaction during
the bulk updates and tried all of the IsolationLevels but with every
iso level the database still shuts me from my read until the row is
released. I am using SqlServer 2000.
Thanks in advance.
 
You should be able to use the (nolock) hint. It will ignore existing
locks and create a schema stability lock (NOTE: the schema-s lock does
not prevent data updates)

HTH

Ray Higdon MCSE, MCDBA, CCNA
 
Back
Top