<div>
You might want to check the current identity value first:<br />
<br />
DBCC CHECKIDENT ('mytable', NORESEED)<br />

</div>


You might want to check the current identity value first:

DBCC CHECKIDENT ('mytable', NORESEED)


<div>
very good article by Mr. Pinal Dave (SQL Server MVP) at <br />
<br />
<a href="http://blog.sqlauthority.com/2009/04/01/sql-server-reseed-identity-of-table-table-missing-identity-values-gap-in-identity-column/" rel="ugc">http://blog.sqlauthority.com/2009/04/01/sql-server-reseed-identity-of-table-table-missing-identity-values-gap-in-identity-column/</a>
</div>


very good article by Mr. Pinal Dave (SQL Server MVP) at

http://blog.sqlauthority.com/2009/04/01/sql-server-reseed-identity-of-table-table-missing-identity-values-gap-in-identity-column/ [http://blog.sqlauthority.com/2009/04/01/sql-server-reseed-identity-of-table-table-missing-identity-values-gap-in-identity-column/]

<div>
Have a look at the following:<br />
<br />
<a href="http://technet.microsoft.com/en-us/library/ms176057.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ms176057.aspx</a><br />
<br />
Good Luck!<br />
<br />
Gary
</div>


Have a look at the following:

http://technet.microsoft.com/en-us/library/ms176057.aspx [http://technet.microsoft.com/en-us/library/ms176057.aspx]

Good Luck!

Gary

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have a column that is auto-incremented, how do I reset its incremental value to 30 for example?<br />
<br />
I need an SQL syntax for that. and the database that this column is in is of MS SQL 2000
</div>
</div>


Hi

I have a column that is auto-incremented, how do I reset its incremental value to 30 for example?

I need an SQL syntax for that. and the database that this column is in is of MS SQL 2000

Reset Identity to some value

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.