title: Reset auto increment
body: <p>My question starts here: <a href="https://stackoverflow.com/questions/39155743/how-to-setup-auto-increment-for-service-based-database">How to setup auto increment for Service-Based Database</a></p>
  
  <p>So if I have to go this way to reset auto increment after deleting a table row: </p>
  
  <p><a href="http://befused.com/mysql/reset-auto-increment" rel="nofollow noreferrer">http://befused.com/mysql/reset-auto-increment</a></p>
  
  <p>first time I have deal with T-SQL extension and SQL generally. What is wrong here, not sure if I got it right: </p>
  
  <pre><code>CREATE TABLE [dbo].[Tab1] (
      [Id]     INT  IDENTITY (1, 1) NOT NULL,
      [Phrase] TEXT NOT NULL,
      PRIMARY KEY CLUSTERED ([Id] ASC)
  );
  
  SELECT MAX( Id ) FROM [Tab1] ;
  ALTER TABLE Tab1 AUTO_INCREMENT = number; 
  </code></pre>
  
  <p>got this errors: </p>
  
  <blockquote>
    <p>Severity Code Description Project File Line Suppression State Error
    SQL80001: Incorrect syntax near ''. Expecting '.', ID, or QUOTED_ID.
    dbo.User 8</p>
  </blockquote>
  
  <p>and: </p>
  
  <blockquote>
    <p>SeverityCode Description Project File Line Suppression State Error
    SQL80001: Incorrect syntax near ''. dbo.User 7</p>
  </blockquote>