Syntax for Reseeding the IDENTITY Value with a New Explicit Value : DBCC « System Settings « SQL Server / T-SQL Tutorial

DBCC CHECKIDENT ('table_name' , RESEED, new_reseed_value)

Reseeding the IDENTITY Value of MyTable with a New Explicit Value

7> CREATE TABLE MyTable (
8>  key_col int NOT NULL IDENTITY (1,1),
9>  abc     char(1) NOT NULL
10> )
11> INSERT INTO MyTable VALUES ('a')
12> INSERT INTO MyTable VALUES ('b')
13> INSERT INTO MyTable VALUES ('c')
14> SELECT * FROM MyTable ORDER BY key_col
15> GO

(1 rows affected)

(1 rows affected)

(1 rows affected)
key_col     abc
----------- ---
          1 a
          2 b
          3 c

(3 rows affected)
1>
2> DBCC CHECKIDENT ('MyTable', RESEED, 50)
3>
4> drop table MyTable
5> GO
Checking identity information: current identity value '3', current column value '50'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
1>

26.4.DBCC
	26.4.1.	Using DBCC CHECKIDENT to View and Correct IDENTITY Seed Values
	26.4.2.	Clearing Out Memory
	26.4.3.	DBCC TRACEON
	26.4.4.	DBCC SHOW STATISTICS (tablename, index_name)
	26.4.5.	dynamically building the DBCC command:
	26.4.6.	Displaying the Oldest Active Transaction with DBCC OPENTRAN and Viewing Lock Activity
	26.4.7.	Syntax for Retrieving the Current IDENTITY Value of a Table and the Correct Value
	26.4.8.	Reseeding the IDENTITY Value
	26.4.9.	Syntax for Reseeding the IDENTITY Value with a New Explicit Value
	26.4.10.	Flushing the Procedure Cache