CheckBlocking-SessionInfo.xml

<BlockedSession>
    <WaitingSpid> 67 </WaitingSpid>
    <BlockingChain> 67 » 64 » 57 </BlockingChain>
    <LoginName> AMallon </LoginName>
    <TransactionCnt> 0 </TransactionCnt>
    <WaitResource> OBJECT WAIT: master.dbo.AM2a </WaitResource>
    <HostName> AMALLON-LT </HostName>
    <DbName> master </DbName>
    <LastRequest> 2017-10-26 22:49:58 </LastRequest>
    <ProgramName> Microsoft SQL Server Management Studio - Query </ProgramName>
    <InputBuffer>
        begin tran
        CREATE TABLE am3a (foo bit);
        SELECT * FROM am2a;
    </InputBuffer>
    <SqlStatement>
        begin tran
        CREATE TABLE am3a (foo bit);
        SELECT * FROM am2a;
    </SqlStatement>
    <SqlText>
        begin tran
        CREATE TABLE am3a (foo bit);
        SELECT * FROM am2a;
    </SqlText>
</BlockedSession>