Truncate statement

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  June 20, 2013 at 4:32 am

  #275449

  Is it possible to rollback a Truncate statement?

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  June 20, 2013 at 4:38 am

  #1625805

  yes it is possible, as long as it is part of a transaction

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 20, 2013 at 4:52 am

  #1625811

  Yes, and it's trivial to test and prove.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass