>-- disable referential integrity >EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' >GO > >EXEC sp_MSForEachTable 'TRUNCATE TABLE ?' >GO > >-- enable referential integrity again >EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL' >GO >I was joking when I said I wanted a script to do everything I wanted. You didn't actually have to go and find me one.