• <deadlock-list>

    <deadlock victim="process15cdabe928">

    <process-list>

    <process id="process15cdabe928" taskpriority="0" logused="0" waitresource="PAGE: 5:3:695694 " waittime="2961" ownerId="592144764" transactionname="SELECT" lasttranstarted="2013-10-28T18:08:06.970" XDES="0x18fbe00d80" lockMode="S" schedulerid="2" kpid="6252" status="suspended" spid="77" sbid="0" ecid="5" priority="0" trancount="0" lastbatchstarted="2013-10-28T18:08:06.967" lastbatchcompleted="2013-10-28T18:08:06.967" lastattention="1900-01-01T00:00:00.967" clientapp=".Net SqlClient Data Provider" hostname="MIHQENETPRDWB02" hostpid="1076" isolationlevel="read committed (2)" xactid="592144764" currentdb="5" lockTimeout="4294967295" clientoption1="536870944" clientoption2="128056">

    <executionStack>

    <frame procname="DatabaseName.SchemaName.Status_GetByPriorAuthorizationId" line="13" stmtstart="606" stmtend="1594" sqlhandle="0x030005000c700442d4347f0161a2000001000000000000000000000000000000000000000000000000000000">

    SELECTStatusId,

    StatusTypeId,

    EffectiveDttm,

    TerminationDttm,

    ActivityId,

    PartyRoleId,

    --RXOrderId,

    OrderItemId,

    PrescriptionId,

    PriorAuthorizationId,

    --ShipmentId,

    StatusReasonTypeId,

    CreatedById,

    CreatedDttm,

    LastEditedById,

    LastEditedDttm,

    DeleteInd,

    RowVersionId

    FROM [Status]

    WHERE PriorAuthorizationId = @PriorAuthorizationId

    AND DeleteInd = 0

    AND (TerminationDttm IS NULL OR TerminationDttm > GETDATE()) </frame>

    </executionStack>

    <inputbuf>

    Proc [Database Id = 5 Object Id = 1107587084] </inputbuf>

    </process>

    <process id="process12bb19d498" taskpriority="0" logused="18912" waitresource="PAGE: 5:3:695693 " waittime="2935" ownerId="592144154" transactionname="user_transaction" lasttranstarted="2013-10-28T18:08:06.860" XDES="0x154264d6a8" lockMode="IX" schedulerid="10" kpid="3616" status="suspended" spid="69" sbid="0" ecid="0" priority="0" trancount="3" lastbatchstarted="2013-10-28T18:08:07.053" lastbatchcompleted="2013-10-28T18:08:07.053" lastattention="1900-01-01T00:00:00.053" clientapp=".Net SqlClient Data Provider" hostname="MIHQENETPRDWB02" hostpid="1076" loginname="userDatabaseName" isolationlevel="read committed (2)" xactid="592144154" currentdb="5" lockTimeout="4294967295" clientoption1="538968096" clientoption2="128056">

    <executionStack>

    <frame procname="DatabaseName.SchemaName.Status_Merge" line="41" stmtstart="2178" stmtend="3718" sqlhandle="0x030005003df20516d6347f0161a2000001000000000000000000000000000000000000000000000000000000">

    UPDATE [SchemaName].[Status] SET

    StatusTypeId = @StatusTypeId,

    StatusTypeText = @StatusTypeText,

    StatusReasonTypeText = @StatusReasonTypeText,

    StatusChildReasonTypeText = @StatusChildReasonTypeText,

    StatusNoteText = @StatusNoteText,

    TerminationDttm = @TerminationDttm,

    ActivityId = @ActivityId,

    ActivityWorkId = @ActivityWorkId,

    PartyRoleId = @PartyRoleId,

    OrderItemId = @OrderItemId,

    PrescriptionId = @PrescriptionId,

    PriorAuthorizationId = @PriorAuthorizationId,

    StatusReasonTypeId = @StatusReasonTypeId,

    LastEditedById = @LastEditedById,

    LastEditedDttm = @LastEditedDttm,

    DeleteInd = @DeleteInd

    OUTPUT inserted.StatusId, inserted.RowVersionId INTO #output

    WHERE StatusId = @StatusId </frame>

    </executionStack>

    <inputbuf>

    Proc [Database Id = 5 Object Id = 369488445] </inputbuf>

    </process>

    </process-list>

    <resource-list>

    <pagelock fileid="3" pageid="695694" dbid="5" subresource="FULL" objectname="DatabaseName.SchemaName.Status" id="lock136b5ede00" mode="IX" associatedObjectId="72057600471728128">

    <owner-list>

    <owner id="process12bb19d498" mode="IX"/>

    </owner-list>

    <waiter-list>

    <waiter id="process15cdabe928" mode="S" requestType="wait"/>

    </waiter-list>

    </pagelock>

    <pagelock fileid="3" pageid="695693" dbid="5" subresource="FULL" objectname="DatabaseName.SchemaName.Status" id="lock1394b32400" mode="S" associatedObjectId="72057600471728128">

    <owner-list>

    <owner id="process15cdabe928" mode="S"/>

    </owner-list>

    <waiter-list>

    <waiter id="process12bb19d498" mode="IX" requestType="wait"/>

    </waiter-list>

    </pagelock>

    </resource-list>

    </deadlock>

    </deadlock-list>