How to read the value of DEADLOCK_PRIORITY

Hi,
a simple question, i want to know the value of DEADLOCK_PRIORITY, where
and/or how to read it ?
Best regards.In 2005, you can get it from the sys.dm_exec_sessions view.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Franck Fouache" <franck.fouache@.ccmx.fr> wrote in message
news:OZh48ksiGHA.3496@.TK2MSFTNGP02.phx.gbl...
> Hi,
> a simple question, i want to know the value of DEADLOCK_PRIORITY, where an
d/or how to read it ?
> Best regards.
>|||i forgot to tell i used SQL2000 / 8.0 ... if you know how to in this version
...
but i'll keep in mind your answer for SQL2005, thanks for your help
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a crit
dans le message de news: %23frqPOuiGHA.4884@.TK2MSFTNGP03.phx.gbl...
> In 2005, you can get it from the sys.dm_exec_sessions view.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Franck Fouache" <franck.fouache@.ccmx.fr> wrote in message
> news:OZh48ksiGHA.3496@.TK2MSFTNGP02.phx.gbl...
>|||I don't think there is a way in 2000. I tried both:
DBCC USEROPTIONS
SELECT @.@.OPTIONS
And none of above seem to reflect this setting. I might be missing something
, of course...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Franck Fouache" <franck.fouache@.ccmx.fr> wrote in message
news:OAwF9C6iGHA.3408@.TK2MSFTNGP05.phx.gbl...
> i forgot to tell i used SQL2000 / 8.0 ... if you know how to in this versi
on ...
> but i'll keep in mind your answer for SQL2005, thanks for your help
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a crit
dans le message de
> news: %23frqPOuiGHA.4884@.TK2MSFTNGP03.phx.gbl...
>

How to read the value of DEADLOCK_PRIORITY

Hi,
a simple question, i want to know the value of DEADLOCK_PRIORITY, where
and/or how to read it ?
Best regards.In 2005, you can get it from the sys.dm_exec_sessions view.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Franck Fouache" <franck.fouache@.ccmx.fr> wrote in message
news:OZh48ksiGHA.3496@.TK2MSFTNGP02.phx.gbl...
> Hi,
> a simple question, i want to know the value of DEADLOCK_PRIORITY, where and/or how to read it ?
> Best regards.
>|||i forgot to tell i used SQL2000 / 8.0 ... if you know how to in this version
...
but i'll keep in mind your answer for SQL2005, thanks for your help
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a écrit
dans le message de news: %23frqPOuiGHA.4884@.TK2MSFTNGP03.phx.gbl...
> In 2005, you can get it from the sys.dm_exec_sessions view.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Franck Fouache" <franck.fouache@.ccmx.fr> wrote in message
> news:OZh48ksiGHA.3496@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> a simple question, i want to know the value of DEADLOCK_PRIORITY, where
>> and/or how to read it ?
>> Best regards.
>|||I don't think there is a way in 2000. I tried both:
DBCC USEROPTIONS
SELECT @.@.OPTIONS
And none of above seem to reflect this setting. I might be missing something, of course...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Franck Fouache" <franck.fouache@.ccmx.fr> wrote in message
news:OAwF9C6iGHA.3408@.TK2MSFTNGP05.phx.gbl...
> i forgot to tell i used SQL2000 / 8.0 ... if you know how to in this version ...
> but i'll keep in mind your answer for SQL2005, thanks for your help
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a écrit dans le message de
> news: %23frqPOuiGHA.4884@.TK2MSFTNGP03.phx.gbl...
>> In 2005, you can get it from the sys.dm_exec_sessions view.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Franck Fouache" <franck.fouache@.ccmx.fr> wrote in message
>> news:OZh48ksiGHA.3496@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> a simple question, i want to know the value of DEADLOCK_PRIORITY, where and/or how to read it ?
>> Best regards.
>>
>