Dangeriz
asked on
Rollback DELETE!
Hi all,
I've just DELETED 19 records from a table just now in SQL Query Analyzer . How do I recover those records, or how do I roll back the transaction? What is the quickest way to recover those records?
I've just DELETED 19 records from a table just now in SQL Query Analyzer . How do I recover those records, or how do I roll back the transaction? What is the quickest way to recover those records?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Soryy to hear this, but as I see you don't have backups, so those records are lost :(
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, I forgot the underscore in my comment!
Thanks for pointing it out, however.
====
Shiva
Thanks for pointing it out, however.
====
Shiva
Scott,
Oops. I overlooked. It should've been ON instead of OFF. I believe this is what you wanted to say, right?
Oops. I overlooked. It should've been ON instead of OFF. I believe this is what you wanted to say, right?
Dangeriz:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
SET IMPLICIT_TRANSACTIONS ON
GO
which forces a transaction to be used, forcing you to explicitly either COMMIT or ROLLBACK.
Of course, when done, use:
SET IMPLICIT_TRANSACTIONS OFF
GO
to return to normal autocommit mode.