SQL Forcing the current identity value to a new value

USE AdventureWorks2012; GO DBCC CHECKIDENT ('Person.AddressType', RESEED, 10); GO http://msdn.microsoft.com/en-ca/library/ms176057.aspx