Post reply

Rollback a transition

  • January 31, 2005 at 11:53 am

    #66442

    My fellow cubical mate just pulled a no-no on a table.  He basically forgot his where clause and updated all the entries.   I won't go into detail on the specifics, but lets just say I want MY data back asap!

    He still has his Query Analyzer open.  Is there a way to Rollback this transaction or is he SOL and will be hand typing my data back in the rest of the day??

  • January 31, 2005 at 12:10 pm

    #539782

    Never mind,

    Thank god we backup daily.  I just restored from backup.

  • January 31, 2005 at 3:14 pm

    #539815

    For future reference, use the SET IMPLICIT_TRANSACTIONS ON statement when working in Query Analyzer.  This way you can use the "rollback" statement to reverse changes, or use the "commit" statement before the changes are applied to the database.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply