job that''s killed but did not commit

• Bikeman

  Ten Centuries

  Points: 1207

  More actions

  March 25, 2005 at 3:23 pm

  #87878

  Hi all,

   

  Let me see if I understand these 2 scenarious:

  1. A job was running a delete (wothout BEGIN...COMMIT), and was killed in the process. It will roll back without performing a delete, right?

  2. If the job was rolled back, or hung, it still didn't delete records. Only if commit was issued (or it finished) the delete would take place?

   

  Thanks

   

   

• hoo-t

  SSChampion

  Points: 12713

  More actions

  March 25, 2005 at 3:47 pm

  #549026

  I think the correct answer would be "It depends".  Have a look at "Controlling Transactions" in Books Online.

  Steve