title: Identity increment is jumping in SQL Server database
body: <p>In one of my tables <code>Fee</code> in column "ReceiptNo" in SQL Server 2012 database identity increment suddenly started jumping to 100s instead of 1 depending on the following two things.</p>
  
  <ol>
  <li><p>if it is 1205446 it is jumps to 1206306, if it is 1206321, it jumps to 1207306 and if it is 1207314, it jumps to 1208306. What I want to make you note is that the last three digits remain constant i.e 306 whenever the jumping occurs as shown in the following picture.</p></li>
  <li><p>this problem occurs when I restart my computer</p></li>
  </ol>
  
  <p><img src="https://i.stack.imgur.com/tmjTp.jpg" alt="enter image description here"></p>