Trace Results - Please Help- Deadlock

SPID40 ECID : 0 STAEMENT TYPE -> GRANT LINE # 1
INPUT BUFFER :-> SP_EXECUTE, 8

SPID 41 ECID: 0 STATEMENT TYPE : UNKNOW TOKEN # :1
INPUT BUFFER :-> SP_CURSORFETCH 8A G 8 8 8

SPID 40 ECID: 0 STATEMENT TYPE : UNKNOW TOKEN # : - 1
INPUT BUFFER :-> SP_EXECUTE, 8

== LOCK KEY 10:973298577:1 (7A0185EF6B8E)
DATABASE : SASETNWT
TABLE: PSLOCK
INDEX : PS_PSLOCK
 HELD BY SPID 40 ECID 0 MODE ‘X’
 REQUESTED BY :SPID 41 ECID 0 MODE ‘S’

== LOCK KEY 10:973298577[ ]
DATABASE : SASETNWT
TABLE: PSLOCK
 HELD BY SPID 40 ECID 0 MODE ‘IS’
 REQUESTED BY :SPID 41 ECID 0 MODE ‘SCHEMA-MOD’


HERE IS WHAT I THINK WHATS GOING ON

First SPID 40 requests a Exclusive lock on the row(key) of table PSlock which is granted by the dB where he is running ‘ Grant sp_execute statement’ !!!

Then SPID 41 request a Shared lock on the table Pslock which is granted by the db where spid 40 is running “ Sp_cursorfetch statement”

Now we have two lock on Pslock table , one by spid 40 with an exculsive lock and other by spid 41 with shared lock.

then spid 40 requests a ‘Schema- mod’ lock on Pslock table which I guess is a table lock
and we have have a dead lock situation here

is the above explanation right ?????


regards

Girish