I have updated a column(first_name) in my table emp.Instead of updating few fields which meats some criteria i have update all the rows in the DB.Its just an update stmt and there is no explicit transaction mentioned.
I dont have a back for the table.So how can i rollback my update statement and get my old data?Any chance?
Restore a backup of your database under a different name, and then Update your current data with the old data based on the table's primary key. You do have a backup, don't you? And you do have a primary key on your table, don't you?
If it's not practically useful, then it's practically useless.
Check out Lumigent's web site for more details. The log explorer is a tool that allows you to see "who done what, when" in your database, and it gives you options for "undoing" what has already been done (which is what you need right now).