ProAnswers.org

What is the best way to remove all the data from all the tables using TSQL?

I do not want to create manually and maintain truncate table statements for each table.

For SQL 2005,

EXEC sp_MSForEachTable ‘TRUNCATE TABLE ?’