Locks and Blocks

Hi all,
I don't understand this.
I had SPID 104 blocked by SPID 87. However, SPID 87 was sleeping. How
can that be?
Please advise.
Audrey
*** Sent via Developersdex http://www.developersdex.com ***A sleeping spid is simply one that isn't currently "doing" anything. It can
certainly be sitting there with a lock on a row/table from an update
statement. A bad example is beginning a transaction, doing an update and
then presenting a message box to a user and wait for them to click 'OK'.
What happens if they wander off for lunch? The resource is locked until
they return or a timeout occurs on the connection.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Audrey Ng" <odd26uk@.yahoo.co.uk> wrote in message
news:uUfKwJNjHHA.3472@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I don't understand this.
> I had SPID 104 blocked by SPID 87. However, SPID 87 was sleeping. How
> can that be?
> Please advise.
> Audrey
> *** Sent via Developersdex http://www.developersdex.com ***