Rollback Trans

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  June 19, 2008 at 12:38 pm

  #192947

  I am trying to test performance for a store proc which does many inserts and updates on the tables.

  I want to test it but dont want to affect anything on the databases, ofocurse its a test environment but still if I have my proc in a transaction and rollback it at the end, will i succeed in inserts,updates getting rolled back to the original position.

• JWOL

  Hall of Fame

  Points: 3471

  More actions

  June 20, 2008 at 5:22 am

  #831643

  Yes, you can be confident that your inserts, updates and deletes will be reversed assuming your using a script something like:

  BEGIN TRAN

  EXEC your_proc

  ROLLBACK