SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work.

In general truncate and reload is the easiest option - for the reason that you don't have to worry about what's changed and any back door updates to the source database will be reflected in the ...