How to find current isolation level in QA session ?

How to find current isolation level in QA session ?DBCC USEROPTIONS
If you didn't change it from read uncommitted, it seems like it is excluded from the result.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:OmCUGAmsDHA.2464@.TK2MSFTNGP12.phx.gbl...
>|||Did you mean READ COMMITTED' It is omitted from the display unless you
explicitly set it to something.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:u7H2bNmsDHA.424@.TK2MSFTNGP11.phx.gbl...
> DBCC USEROPTIONS
> If you didn't change it from read uncommitted, it seems like it is
excluded from the result.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OmCUGAmsDHA.2464@.TK2MSFTNGP12.phx.gbl...
> >
> >
>|||> Did you mean READ COMMITTED'
Oops. Yes, I did. Thanks for catching that.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"SriSamp" <ssampath@.sct.co.in> wrote in message news:u54S5jmsDHA.2400@.tk2msftngp13.phx.gbl...
> Did you mean READ COMMITTED' It is omitted from the display unless you
> explicitly set it to something.
> --
> HTH,
> SriSamp
> Please reply to the whole group only!
> http://www32.brinkster.com/srisamp
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:u7H2bNmsDHA.424@.TK2MSFTNGP11.phx.gbl...
> > DBCC USEROPTIONS
> >
> > If you didn't change it from read uncommitted, it seems like it is
> excluded from the result.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OmCUGAmsDHA.2464@.TK2MSFTNGP12.phx.gbl...
> > >
> > >
> >
> >
>