• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 667
  • Last Modified:

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
0
deepakee
Asked:
deepakee
  • 3
1 Solution
 
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
 
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
 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now