DBCC USEROPTIONS


I’ve just run DBCC USEROPTIONS to check the current isolation level of the connection, but the isolation level is not shown.

I get all the other options (textsize,… concat_null_yields_null).

Why?

Thank you,
Deepak
deepakeeAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
again if you change back to read committed , it will display,

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

DBCC USEROPTIONS

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

DBCC USEROPTIONS
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
If you didn't change it from read committed, it seems like it is excluded from the result.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
change the isolation level to something else and run the DBCC USEROPTIONS agaain
0
 
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
HI in SQL 2005 i can see Isolation Level it shows me ReadCommitted

and you can find out ISolation Level at the last records..

please check againnn
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.