title: What will append if the maximum value of an identity column is reached?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/5305232/what-happens-to-the-primary-key-id-when-it-goes-over-the-limit">What happens to the primary key Id? when it goes over the limit?</a>  </p>
  </blockquote>
  
  
  
  <p>what will append if have an SQL server table with an identity column (says an int) that reaches the maximal capacity of the int ?</p>
  
  <p>Go back to the beginning ?</p>
  
  <p>Assume that the lines grow 100 by 100. Each time I insert 100 new lines, I delete the 100 old ones.</p>
  
  <p>Thanks for your answer
  Best regards</p>