SQLUSA

Microsoft SQL Server 2000

Best Practices

 

How to reseed the identity value on a table?

 

One way of doing it is using dbcc:

DBCC CHECKIDENT (TableX, RESEED, 30)

Second way: turn identity insert off, do an insert with the new seed, turn identity insert on.

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page