title: Arithmetic overflow error converting IDENTITY to data type tinyint
body: <p>I am designing table in SQL Server 2008 R2 SP2 Express database. I created table with <code>nvarchar</code> column for data and <code>tinyint</code> column for auto-incrementing identity assuming there will be no more than few rows (that's why I choose 0-255 <code>tinyint</code>). When I add more than 255 rows, this error keeps occurring permanently even after I delete all rows in that table and try to add one new row. I am doing this using SQL Server Management Studio Express.</p>
  
  <ol>
  <li>How to force database engine to check what indexes are free?  </li>
  <li>Will this happen too if I change <code>tinyint</code> to <code>int</code> and reach limit of <code>int</code> number?</li>
  </ol>