Early Versions (SQL Server 2000 – 2008)
Reset Identity Values
Early Versions (SQL Server 2000 – 2008)Reset Identity ValuesReset Identity Values
Use a stored T-SQL procedure called ResetIdentities.sql to globally reset all identity values in a database to their initial seed value.
byReaders
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.