An old one, but worth remembering...

Resetting the identity value of any SQL table is as easy as follows:

USE AdventureWorks2012;
GO
DBCC CHECKIDENT ('Person.AddressType', RESEED, 10);
GO

http://technet.microsoft.com/en-us/library/ms176057.aspx