USE [BO] GO EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all" GO EXEC sp_msforeachtable "DELETE FROM ?" GO EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all" GO EXEC sp_msforeachtable "DBCC CHECKIDENT('?', RESEED, 1)" GO