-- Check Current Identity Seed DBCC CHECKIDENT ('tbTable01', NORESEED); -- Reseed Identity Column DBCC CHECKIDENT ('tbTable01', RESEED, 1001)
The seed is good if the current identity value is equal to or greater than the current value.
Checking identity information: current identity value '1033', current column value '1033'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
- If you are using SQL Compare to update table, don’t run the RESEED statement.
- May have to run the reseed statement multiple times if there are already data rows with the existing seed.
DBCC CHECKIDENT ('tbTable01', RESEED, 1025) DBCC CHECKIDENT ('tbTable01', RESEED, 1025)