title: How to update lots of rows with out locking table in SQL Server 2008?
body: <p>I have a job which is updating a table for 20 minutes and at these moments I can't update any row of it naturally.</p>
  
  <p>Is there a way or method for to do this ?</p>
  
  <p>The job can be more longer but I have to continue to update table.</p>
  
  <p>On the other hand the job should rollback if it has got error during job.</p>
  
  <p>Thanks..</p>