Rollback in Sql query window

• jollyguy4all

  SSC Veteran

  Points: 270

  More actions

  August 20, 2003 at 6:07 am

  #106980

  Hi,

  I use ms sql query analyzer/window to run my queries and do bulk updates / inserts/ deletes as everyone might do.

  Sometimes while i am updating a bunch of records there are times when i by mistake write a wrong condition and all records get updated with a particular value. Is there a way to roll back such statements?

  I have to deal with a users database of more than 100K and in such situations when say i am udation job titles of people and if such and error occurs it can spell disaster.

  Please advise and oblige.

  Thanks and regards

  Hitendra

• brokenrulz

  SSCrazy

  Points: 2261

  More actions

  August 21, 2003 at 12:00 am

  #470696

  Have you tried keeping Sets implicit transaction mode to on for the connection.

  Command is SET IMPLICIT_TRANSACTIONS ON

  This way you will need to manually rollback or commit a transaction

  else all changes will be lost once you close the connection.

  Pay Respect to People on your way up. For you will meet the same People on your way down.

  
  He who knows others is learned but the wise one is one who knows himself.