thanks will do so<br><br><div class="gmail_quote">On Tue, Oct 26, 2010 at 10:39 AM, Rad! <span dir="ltr">&lt;<a href="mailto:conradakunga@gmail.com">conradakunga@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
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"><div><div></div><div class="h5">On Tue, Oct 26, 2010 at 10:08 AM, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com" target="_blank">calvinebarongo@gmail.com</a>&gt;</span> wrote:<br>

</div></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div class="h5">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></div></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">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>
<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><br clear="all"><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">http://www.facebook.com/barongo</a> <br>