Running and sleeping processes

Hi there,
Can somebody tell me the differences between SLEEPING and RUNNING
processes? I cannot find an explaination in BOL. If there is a thread on
this issue somewhere, can you put a link?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sleeping status indicates that the SPID has completed execution and is
waiting for the application to submit another query or batch. A runnable
status indicates the SPID is currently processing a query
See
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
PSS ID Number: 224453
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hans Brouwer" <hansbrouwer@.hotmail.com> wrote in message
news:u$XIjMJlDHA.2500@.TK2MSFTNGP10.phx.gbl...
> Hi there,
> Can somebody tell me the differences between SLEEPING and RUNNING
> processes? I cannot find an explaination in BOL. If there is a thread on
> this issue somewhere, can you put a link?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!