[RESOLVED] reset auto_number field in SQL Server

[ober0330]

I have my reasons, so don't ask me why. I have an auto_number field in a database and that number is currently up to ~80,000 after some testing I've done. I'd like to reset that number to 0.

Anyone know how? SQL Server 2K SP3.

[nkad]

In mysql you would use the expression

AUTO_INCREMENT = 0

in an update or alter statement
In sql server, you do this:

 DBCC CHECKIDENT('table_name', RESEED, 0)

http://msdn.microsoft.com/library/de..._dbcc_5lv8.asp

[ober0330]

Perfect. Thanks!