Can I rollback a delete?

Hi!
I made a wrong delete in my database.
Can I recover the data of that table??
The query was:
delete from table
I should write something like this
delete from table where column = 87
ThanksSure..

BEGIN TRAN

DELETE FROM myTable99

ROLLBACK TRAN

...you didn't create a transaction?

Time to restore the DB from a backup to a new db and copy the data from there...

No back up?

How about printed listings and start typing?|||No printed listings ...
Better think of some excuse fast.

Any way have heard of a third party tool that might help .. am not sure .. something called log explorer from lumigent. Havent tried it out yet.|||Thank you!...Im now searching the backup information...Now the question is if I can restore only that table?

How?

Thanks

JP
Originally posted by Enigma
No printed listings ...
Better think of some excuse fast.

Any way have heard of a third party tool that might help .. am not sure .. something called log explorer from lumigent. Havent tried it out yet.|||No,

You can only restore the whole database...

DON"T overlay the existsing one, create a new DB (use attach), and then copy back the lost data...|||Yep, I have just started to try out Lumigent Log Explorer and it sure can recover deletes and other changes from the log.

Haven't done anything more than some small trials on it yet, but it don't seem to hard to use.

http://www.lumigent.com/products/le_sql/le_sql.htm|||Restore on to a new db, bcp out the table you want and bcp in into the old db

You might wanna check for dependencies of the table ..|||What's the cost? Is there a free demo?

Heard about it..never had a need...|||Havent had the need to use the log explorer till now ... my backups work just fine ... and i just bcp out the entire database tables once a day to take care of such cases. Takes care of such cases where data is accidently deleted or updated very fast.