Home Forums Article Discussions Article Discussions by Author Discuss content posted by Craig Farrell TRUNCATE TABLE and ROLLBACK TRAN RE: TRUNCATE TABLE and ROLLBACK TRAN

  • February 6, 2012 at 12:20 am

    #1442909

    Koen Verbeeck (2/5/2012)

    Henrico Bekker (2/5/2012)

    Thanks for the question, but please explain why:

    No, you can never rollback a transaction with a TRUNCATE TABLE statement, regardless of recovery mode

    isn't also correct?

    Because you can rollback a transaction with a TRUNCATE TABLE statement?

    Tsk, thanks Koen....

    Slow Monday morning for me....ignore me for the day ...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle