Thanks as always. I did learn something from that.
Ok, here's an easier one Erland. What can I infer from this?
Deadlock encountered .... Printing deadlock information
2005-01-13 09:00:10.64 spid4
2005-01-13 09:00:10.64 spid4 Wait-for graph
2005-01-13 09:00:10.64 spid4
2005-01-13 09:00:10.64 spid4 Node:1
2005-01-13 09:00:10.64 spid4 KEY: 7:1038026504:2 (17018f579faa)
CleanCnt:1 Mode: X Flags: 0x0
2005-01-13 09:00:10.64 spid4 Grant List 0::
2005-01-13 09:00:10.64 spid4 Owner:0x6746f520 Mode: X
Flg:0x0 Ref:0 Life:02000000 SPID:62 ECID:0
2005-01-13 09:00:10.64 spid4 SPID: 62 ECID: 0 Statement Type:
DELETE Line #: 122
2005-01-13 09:00:10.64 spid4 Input Buf: RPC Event:
Requisition_Scansample;1
2005-01-13 09:00:10.64 spid4 Requested By:
2005-01-13 09:00:10.64 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:57 ECID:0 Ec
0x70E27590) Value:0x7102e5c0 Cost
0/A10)
2005-01-13 09:00:10.64 spid4
2005-01-13 09:00:10.64 spid4 Node:2
2005-01-13 09:00:10.64 spid4 KEY: 7:1811953977:6 (420154596011)
CleanCnt:1 Mode: X Flags: 0x0
2005-01-13 09:00:10.64 spid4 Grant List 3::
2005-01-13 09:00:10.64 spid4 Owner:0x550cdac0 Mode: X
Flg:0x0 Ref:0 Life:02000000 SPID:57 ECID:0
2005-01-13 09:00:10.64 spid4 SPID: 57 ECID: 0 Statement Type:
CONDITIONAL Line #: 59
2005-01-13 09:00:10.64 spid4 Input Buf: RPC Event:
Requisition_Scansample;1
2005-01-13 09:00:10.64 spid4 Requested By:
2005-01-13 09:00:10.64 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:62 ECID:0 Ec
0x670F7590) Value:0x718e8680 Cost
0/27E4)
2005-01-13 09:00:10.64 spid4 Victim Resource Owner:
2005-01-13 09:00:10.64 spid4 ResType:LockOwner Stype:'OR' Mode: S
SPID:57 ECID:0 Ec
0x70E27590) Value:0x7102e5c0 Cost
0/A10)
2005-01-13 09:01:00.97 spid4
Thanks..