Isolation Levels

[Reza]

How do you find out what the current isolation level of your SQL Server database
is? I have noticed that you can set the value, but I haven't been able to
find a way to find out what the current setting is.

thanks

[Dennis Rehm]

Use the statement:

dbcc useroptions

Multiple rows are returned. Look for one with Set Option = isolation level.
The Value column will contain the isolation level. If there isn't such a
row, the isolation level is the default value "Read Committed".

Dennis


"Reza" <rkhalili@hotmail.com> wrote:
>
>How do you find out what the current isolation level of your SQL Server
database
>is? I have noticed that you can set the value, but I haven't been able
to
>find a way to find out what the current setting is.
>
>thanks