title: How do I Create an AutoCounter Column in a Table in SQL 2008 R2?
body: <p>There is nothing in the "Data Type" drop-down that indicates an auto-counter.<br>
  I selected <code>int</code> and I am assuming there is a setting somewhere else to turn it into an auto-counter.<br>
  The idea is to have a 100% unique ID for my primary key, and every time a row is added it gets the next available ID number assigned to it.</p>
  
  <p><a href="http://img64.imageshack.us/img64/2472/primarykey.png" rel="nofollow noreferrer">http://img64.imageshack.us/img64/2472/primarykey.png</a></p>