title: SQL Server 2008 - adding a column to a replicated table fails
body: <p>We have scenario:</p>
  
  <ul>
  <li>SQL Server 2008</li>
  <li>we have replication on the db</li>
  <li>we have simple sproc that performs ALTER of one of the table (add new column)</li>
  <li>isolation level is default (READ COMMITTED)</li>
  </ul>
  
  <p>Stored procedure fails with error:</p>
  
  <blockquote>
    <p>You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels</p>
  </blockquote>
  
  <p>Questions:</p>
  
  <ul>
  <li>What causes the problem?</li>
  <li>How to fix that?</li>
  </ul>
  
  <p><strong>UPDATE:</strong>
  I believe this is very common problem so I'm wonder why there is no good explanations why replication causes this issue</p>