• A log recovery tool such as SQL Log Rescue might be something you'd find useful in situations like this. It's not a replacement for managing transactions but it can be very handy for recovering from accidental modifications.

    http://www.red-gate.com/products/SQL_Log_Rescue/index.htm