title: Auto number fields
body: <p>I have a field in my SQL Server 2008 table that is auto number incremental of 1 and has over 100,000 records in it.</p>
  
  <p>We are migrating servers at the moment so I'm looking at doing a little spring cleaning and will be deleting all the records from this table.</p>
  
  <p>I still want the auto number incremental of 1 facility but I would like the first record to start at 102001, is this possible.</p>
  
  <p>Thanks.</p>