deepakee
asked on
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
If you didn't change it from read committed, it seems like it is excluded from the result.
change the isolation level to something else and run the DBCC USEROPTIONS agaain
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
and you can find out ISolation Level at the last records..
please check againnn