thanks will do so On Tue, Oct 26, 2010 at 10:39 AM, Rad! <conradakunga@gmail.com> wrote:
Pole mzee.
You cannot roll back a transaction unless you executed the update statement within the context of a transaction.
Your best bet is to rollback to a previous backup.
You *DO* backup, don't you?
In the future run your queries like this
*BEGIN TRAN* * * *Update table set blah = blah blah*
If you make a mess in the update statement simply type and execute
*rollback*
On Tue, Oct 26, 2010 at 10:08 AM, Calvin Omari <calvinebarongo@gmail.com>wrote:
Hi Techies I have mistakenly updated a table in mssql and i would like to undo the changes but roll back the transaction would not work any idea Thanks
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us.
Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us. Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo