Home Forums SQL Server 2005 Administering rollback delete command RE: rollback delete command

  • July 18, 2008 at 4:49 am

    #844904

    shiwani2002sg (7/18/2008)

    if by chance i run a delete command ,n sme rows from some table get deleted ,then what is the command to rollback the command or immediate command. so that i can retrieve the deleted rows

    Unless you started an explicit transaction before you ran the delete, there is no command that will retrieve the rows. You will have to locate a backup of the database.

    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