SQL Server Reset Identity Increment for all tables
Do you have lots of tables which do not have a seed and increment of 1 ?? If not (by default, all tables have that), use this code: exec sp_MSforeachtable @command1 = ‘DBCC CHECKIDENT(”?”, RESEED, 1)’ MSforeachtable is an undocumented, but extremely handy stored proc which executes a given command against all tables in your … Read more