• Amazing question. Thank you.

    Now I must confess that I got it right completely by luck but with a trail of thought that TRUNCATE TABLE is minimally logged and doesn't affect individual rows.

    Is that what the article from Kimberly Tripp explained?

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA