sql server programming: There is a product by Lumigent called Log Explorer that will allow you to
look thru your transaction lags and recover the table. There isnt any other
stratightforward way to do it.

Dave Walden


[quoted text, click to view]

You can just hit Ctrl+Z. :)

Just kidding, If you know what data you deleted, you could restore the tran
log to a test database and send teh deleted data back to your production
database.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
--
[quoted text, click to view]

Hello there

I've made by mistake a delete of data from table on the query Analyzer

Is there a way to undo the last action or roll it back?

If you post the same message twice with two different subjects, will you get
different answers? No, cannot be done unless within a explicit transaction.
SQL issues an implicit transaction that ends after the DML, and because one
of the ACID properties is Durability, your change hse been made.

If you have a backup, then restore it to a different db and get it back that
way.

--
----------------------------------------------------------------------------
-----------
Louis Davidson (drsql@hotmail.com)
Compass Technology Management

Pro SQL Server 2000 Database Design
http://www.apress.com/book/bookDisplay.html?bID=266


[quoted text, click to view]