• TRUNCATE can actually be rolled back. See my recent thread here:

    http://www.sqlservercentral.com/Forums/Topic1361513-1292-1.aspx