Reset auto increment
<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>