Pole mzee.<div><br></div><div>You cannot roll back a transaction unless you executed the update statement within the context of a transaction.</div><div><br></div><div>Your best bet is to rollback to a previous backup.</div>
<div><br></div><div>You *DO* backup, don&#39;t you?</div><div><br></div><div>In the future run your queries like this</div><div><br></div><div><i>BEGIN TRAN</i></div><div><i><br></i></div><div><i>Update table set blah = blah blah</i></div>
<div><br></div><div><br></div><div>If you make a mess in the update statement simply type and execute </div><div><br></div><div><i>rollback</i><br><br><div class="gmail_quote">On Tue, Oct 26, 2010 at 10:08 AM, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com">calvinebarongo@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi Techies<br>I have mistakenly updated a table in mssql and i would like to undo the changes but roll back the transaction would not work<br>
any idea<br>Thanks<br clear="all"><font color="#888888"><br>-- <br>Our greatest fear is not that we are inadequate,<br>
but that we are powerful beyond measure.<br>It is our light, not our darkness, that frightens us.<br><br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> <br>


</font><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div>