title: Auto increment primary key in SQL Server Management Studio 2012
body: <p>How do I <code>auto increment</code> the <code>primary key</code> in a <code>SQL Server</code> database table? I've had a look through the forum but can't see how to do this.</p>
  <p>I've looked at the properties but can't see an option. I saw an answer where you go to the <code>Identity</code> specification property and set it to yes and set the <code>Identity increment</code> to <strong>1</strong>, but that section is grayed out and I can't change the <em>no</em> to <em>yes</em>.</p>
  <p>There must be a simple way to do this but I can't find it.</p>