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.