[RESOLVED] reset auto_number field in SQL Server

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.

In mysql you would use the expression

Code:

---

AUTO_INCREMENT = 0

---

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

Code:

---

DBCC CHECKIDENT('table_name', RESEED, 0)

---

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

Perfect. Thanks!