info about sysprocesses

21 Oct 2005 7:37 AM

Enric

Dear all,

I want to know all the possible values for the status field bring up for
sysprocesses table. Values such 'running' or 'sleeping' seems very
evident but there is one so-called 'DEF-WK...' or something like that which
I haven't idea.

In this occasion I am not be able to find it inside the BOL

Does anyone know how do I figure out such values?

Thanks in advance,

Enric

23 Oct 2005 11:26 AM

Mike Epprecht (SQL MVP)

Hi

Look at the code from the system SP sp_who2

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

Show quote

"Enric" <En***@discussions.microsoft.com> wrote in message
news:C9B83081-19A4-4A33-AD4C-F75AE450B394@microsoft.com...
> Dear all,
>
> I want to know all the possible values for the status field bring up for
> sysprocesses table. Values such 'running' or 'sleeping' seems very
> evident but there is one so-called 'DEF-WK...' or something like that
> which
> I haven't idea.
>
> In this occasion I am not be able to find it inside the BOL
>
> Does anyone know how do I figure out such values?
>
> Thanks in advance,
>
> Enric