I deleted all rows from 20 tables after disabling the constraints, triggers using the stored proc SP_MsForEachTable. Now before the import happens, I need to reseed all the identity columns back to start auto numbering from 1.
So I created a stored procedure that pass in the table name as a parameter, since it seems this will take time as its doing it individually, is there another way to do this for all of the tables at once?
CREATE PROCEDURE [dbo].[USP_ReseedID] @table_name varchar(50) AS BEGIN DBCC CHECKIDENT ( @table_name, RESEED, 0) END