ramadadi
asked on
how to rollback update statement in sql server 2005
Hi Experts,
I have updated one table coumn, with out where clause, it has updated all the column data withe the same value.
ex. update <table> set Column1 = 'Abc'
is there any way to get the previous data, before updating table, i am not using transactions.
I have updated one table coumn, with out where clause, it has updated all the column data withe the same value.
ex. update <table> set Column1 = 'Abc'
is there any way to get the previous data, before updating table, i am not using transactions.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can either restore the backup of the database or use tool like Lumigent Log explorer to revert the changes
Regards,
Aneesh