Pressing stop button is canceling what it did not execute yet ! Unless
you've opened a transaction at the begining.

Regarding the single Update statatment, this is considered transactional
, either updates all the lines, either none.



-----Original Message-----
From: Vihang Gangan
[mailto:mssqldba-ezmlmshield-x31232614.[Email address protected]
Sent: Thursday, April 28, 2005 3:11 PM
To: LazyDBA Discussion
Subject: Rollbacks of selection in query analyser

Hi guys,



When you want to run a particular section of the query, you normally
select that portion and press F5 to run it.



1. Now what will happen if I press cancel button (red square) when the
query is running



2. If it is an update query, will the data written to the table be
rolled back.



3. Also if in case of a stored procedure which updates the table.



Currently I have two recursive procedures under the selection and I am
canceling in between, will the updation

Done in these procedure be rolled back.



4. What if one procedure has finished its execution





I am quite new to sql server hence a detail description would be helpful



Thanx in advance

bye



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page