title: How can you track the progress of a SQL update?
body: <p>Let's say I have an update such as:</p>
  
  <pre><code>  UPDATE [db1].[sc1].[tb1] 
    SET c1 = LEFT(c1, LEN(c1)-1) 
    WHERE c1 like '%:'
  </code></pre>
  
  <p>This update is basically going to go through millions of rows and trim the colon if there is one in the c1 column.</p>
  
  <p>How can I track how far along in the table this has progressed?</p>
  
  <p>Thanks</p>
  
  <p>This is sql server 2008</p>