• The script on the link below does a very good job of this without making any schema modifications, so it is a safer way to go.

    Truncate All Tables

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65341