title: SQL Server 2008 R2. Incorrect syntax near 'AUTO_INCREMENT'
body: <p>Why do i get the following error </p>
  
  <pre><code>Incorrect syntax near 'AUTO_INCREMENT'.
  </code></pre>
  
  <p>while trying to execute</p>
  
  <pre><code>CREATE TABLE Person
  (
      P_Id int NOT NULL AUTO_INCREMENT,
      Name varchar(255),
  
      PRIMARY KEY (P_Id)
  )
  </code></pre>
  
  <p>What is the correct syntax?</p>