Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    6

    Unanswered: Current Isolation Level

    Hi,
    how can I get current isolation level?

    I heard, dbcc useroptions can retrieve it, but I don't see anything
    about isolation level in the result set.
    Is there another way?

    thanks.

  2. #2
    Join Date
    Dec 2002
    Location
    Amsterdam
    Posts
    12

    Re: Current Isolation Level

    Originally posted by Wolffie
    Hi,
    how can I get current isolation level?

    I heard, dbcc useroptions can retrieve it, but I don't see anything
    about isolation level in the result set.
    Is there another way?

    thanks.
    To determine the transaction isolation level currently set, use the DBCC USEROPTIONS statement, for example:

    USE pubs
    GO
    SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
    GO
    DBCC USEROPTIONS
    GO

Posting Permissions

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