The big clean up - Delete all data and reset all identity fields in MS Sql Server

dbcleanup.sql

 -- disable all constraints
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT all' 

-- delete data in all tables 
EXEC sp_MSForEachTable 'DELETE FROM ?' 

-- enable all constraints 
EXEC sp_MSForEachTable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all' 

-- reseed identity columns 
EXEC sp_MSForEachTable ' 
 IF OBJECTPROPERTY(object_id(''?''), ''TableHasIdentity'') = 1 
 DBCC CHECKIDENT (''?'', RESEED, 0) 
'