Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Unanswered: Transaction roll back script

    I would like implement SQL transaction roll back on ALL SQL queries run on our servers.

    However my SQL is not so hot so I was wondering if anyone uses something like this and has a script they can share?

    I need it to work like this....

    Run query and allow roll back

    Allow user to check results are as expected

    Run query again and do for real

    Any ideas?



  2. #2
    Join Date
    May 2002
    Take a look at "SET IMPLICIT_TRANSACTIONS { ON | OFF }" in sql book online for details. You should be able to implement something.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts