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

    Unanswered: set transaction isolation level in stored procedure

    does anone know how to set the transaction isolation level in a stored procedure?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    I am not sure how to do it exactly. It is done on the bind process. If you are using the SPB, there is a bind option in the environment options. If not, you would have to manual bind the SP with the appropriate isolation level.

    There is a way to set the isolation level for each select statement; this overrides any isolation level current in effect. just add the WITH <is>
    where <is> is either RR, RS, CS, or UR. I have done this and it works fine.



Posting Permissions

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