<deadlock-list>
<deadlock victim="processc3eef8">
<process-list>
<process id="processc3eef8" taskpriority="0" logused="2316" waitresource="KEY: 11:72057603266445312 (bc003d4a6ac6)" waittime="1265" ownerId="227297079" transactionname="user_transaction" lasttranstarted="2013-03-27T09:06:21.780" XDES="0x96b89a50" lockMode="U" schedulerid="1" kpid="3216" status="suspended" spid="59" sbid="0" ecid="0" priority="0" transcount="2" lastbatchstarted="2013-03-27T09:02:30.957" lastbatchcompleted="2013-03-27T09:02:24.097" clientapp="Microsoft SQL Server Management Studio - Query" hostname="blankedout" hostpid="3840"
loginname="blankedout" isolationlevel="read committed (2)" xactid="227297079" currentdb="11" lockTimeout="4294967295" clientoption1="673319008" clientoption2="390200">
<executionStack>
<frame procname="madeupdb.dbo.trgUpdateMadeUpName" line="51" stmtstart="2926" stmtend="3316" sqlhandle="0x03000b008eb92a797d4acd0072a100000000000000000000">
Update b set Draw_Date=d.draw_date
from tableA b
inner join tableB d with (nolock) on b.draw_no=d.draw_no
and left(b.game,2)='UK' and b.Draw_Date is null </frame>
<frame procname="madeupdb.dbo.SP_MEM_NODE_PAYMENT_INSERT" line="19" stmtstart="1006" stmtend="1560" sqlhandle="0x03000b00a3b8842785a31f01da9e00000100000000000000">
insert into mem_node_payment(params here)
values(params here) </frame>
<frame procname="madeupdb.dbo.SP_NONE_PAYMENT" line="156" stmtstart="10248" stmtend="10554" sqlhandle="0x03000b002d916b7762853201f6a000000100000000000000">
exec SP_MEM_NODE_PAYMENT_INSERT params here </frame>
<frame procname="madeupdb.dbo.SP_RECORD" line="65" stmtstart="5278" stmtend="5532" sqlhandle="0x03000b00dbcf071433b9510104a100000100000000000000">
exec SP_NONE_PAYMENT params here</frame>
<frame procname="madeupdb.dbo.SP_CONFIRMED" line="62" stmtstart="3668" stmtend="3828" sqlhandle="0x03000b00c0a66d208b76a90017a100000100000000000000">
exec SP_RECORD params here </frame>
<frame procname="adhoc" line="6" stmtstart="112" stmtend="412" sqlhandle="0x0200000022524113d31d57be58017a1c0d1d6a11d3d433a3">
EXEC SP_CONFIRMED @table_name = 'sys_transaction' /* VARCHAR(50) */,
@pk_id = 1000568271 /* INT */,
@amt_ext = 5 /* MONEY */ </frame>
</executionStack>
<inputbuf>
DECLARE @I int
SET @I = 1
WHILE @I <= 2000
BEGIN
EXEC SP_CONFIRMED @table_name = 'sys_transaction' /* VARCHAR(50) */,
@pk_id = 1000568271 /* INT */,
@amt_ext = 5 /* MONEY */
SET @I = @I + 1
END
</inputbuf>
</process>
<process id="processecb198" taskpriority="0" logused="3148" waitresource="PAGE: 11:1:1554543" waittime="1156" ownerId="227297052" transactionname="user_transaction" lasttranstarted="2013-03-27T09:06:21.750" XDES="0x8b79c700" lockMode="U" schedulerid="3" kpid="604" status="suspended" spid="58" sbid="2" ecid="0" priority="0" transcount="2" lastbatchstarted="2013-03-27T09:06:21.750" lastbatchcompleted="2013-03-27T09:06:21.750" clientapp="EntityFrameworkMUE" hostname="hostgoeshere" hostpid="1908"
loginname="blankedout" isolationlevel="read committed (2)" xactid="227297052" currentdb="11" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056">
<executionStack>
<frame procname="madeupdb.dbo.trgUpdateMadeUpName" line="91" stmtstart="6156" stmtend="6652" sqlhandle="0x03000b008eb92a797d4acd0072a100000000000000000000">
Update b set syd_id=d.syd_id
from tableA b
inner join tableC d with (nolock) on b.syd_pers_id=d.syd_pers_id
--and b.game='es_lotto'
and b.game=d.game and isnull(b.syd_id,0)=0 </frame>
<frame procname="madeupdb.dbo.SP_MEM_NODE_PAYMENT_INSERT" line="19" stmtstart="1006" stmtend="1560" sqlhandle="0x03000b00a3b8842785a31f01da9e00000100000000000000">
insert into mem_node_payment(params here)
values(params here) </frame>
<frame procname="madeupdb.dbo.SP_NONE_PAYMENT" line="156" stmtstart="10248" stmtend="10554" sqlhandle="0x03000b002d916b7762853201f6a000000100000000000000">
exec SP_MEM_NODE_PAYMENT_INSERT params here</frame>
<frame procname="madeupdb.dbo.SP_RECORD" line="65" stmtstart="5278" stmtend="5532" sqlhandle="0x03000b00dbcf071433b9510104a100000100000000000000">
exec SP_NONE_PAYMENT params here</frame>
<frame procname="madeupdb.dbo.SP_CONFIRMED" line="62" stmtstart="3668" stmtend="3828" sqlhandle="0x03000b00c0a66d208b76a90017a100000100000000000000">
exec SP_RECORD params here </frame>
<frame procname="adhoc" line="1" stmtstart="118" sqlhandle="0x01000b00b691f53320ccd91c010000000000000000000000">
EXEC sp_confirmed params here </frame>
<frame procname="unknown" line="1" sqlhandle="0x000000000000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@table_name nvarchar(19),@pk_id int,@amt_ext decimal(5,4))EXEC sp_confirmed @table_name, @pk_id, @amt_ext </inputbuf>
</process>
</process-list>
<resource-list>
<pagelock fileid="1" pageid="1554543" dbid="11" objectname="madeupdb.dbo.tableA" id="lock105e0b680" mode="IX" associatedObjectId="72057603266510848">
<owner-list>
<owner id="processc3eef8" mode="IX"/>
</owner-list>
<waiter-list>
<waiter id="processecb198" mode="U" requestType="convert"/>
</waiter-list>
</pagelock>
<keylock hobtid="72057603266445312" dbid="11" objectname="madeupdb.dbo.tableA" indexname="IX_tableA_Draw_Date" id="lock149f6cf00" mode="X" associatedObjectId="72057603266445312">
<owner-list>
<owner id="processecb198" mode="X"/>
</owner-list>
<waiter-list>
<waiter id="processc3eef8" mode="U" requestType="wait"/>
</waiter-list>
</keylock>
</resource-list>
</deadlock>
</deadlock-list>