Cancelling query

• pzmrcd

  Default port

  Points: 1419

  More actions

  October 16, 2009 at 10:53 am

  #136469

  Hi

  Say we have a script that is enclosed in a Transaction .

  If we run this on the server and encounter a problem..if at this stage we click cancel transaction will the changes be undone and all the changes rolled back.

  Thanks

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  October 16, 2009 at 1:07 pm

  #1067137

  Yes if you used

  begin tran

  something happens

  you can issue

  rollback tran

  Alex S