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

    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?

    Thanks

    FunkyD

  2. #2
    Join Date
    May 2002
    Posts
    299
    Take a look at "SET IMPLICIT_TRANSACTIONS { ON | OFF }" in sql book online for details. You should be able to implement something.
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

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