Mark,

FYI: I changed the one line to:

select

MainLock.Process.value('@id', 'varchar(100)') AS LockID,

OwnerList.Owner.value('@id', 'varchar(200)') AS ProcessId,

MainLock.Process.value('local-name(.)','varchar(100)') AS LockType,

MainLock.Process.value('@objectname','sysname') AS ObjectName,

OwnerList.Owner.value('@mode', 'varchar(10)') AS LockMode

from @DeadlockGraph.nodes('/deadlock-list/deadlock/resource-list') AS Lock(list)

OUTER APPLY Lock.list.nodes('*') AS MainLock(Process)

OUTER APPLY MainLock.Process.nodes('owner-list/owner') AS OwnerList(Owner)

;

so that it will handle any node at that level. Looking great, and now it will handle the threadpool and resourceWait locks.