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.

I've worked on several large SQL systems and while I've seen plenty of foreign key constraints in use I've never actually seen them do anything besides cause problems during dataloads and ad-hoc ...