How do I... Reseed a SQL Server identity column?
Source: Susan Harkins
Microsoft SQL Server's identity column generates sequential values for new records using a seed value. You can control the column's first and subsequent values, by specifying those values when you create the column. The good news is that seeding and reseeding an identity column is easy and relatively safe, if you do it correctly. Susan Sales Harkins shows you how it works.
This download is also available as a blog entry in the TechRepublic Servers and Storage blog.