ShowBlockTree
Shows the tree of blocking processes, the processes they block and the resources being waited on. The tree is returned as a message.
ShowBlockTree()
Permissions
Requires an account that is a member of an administrator role.EXEC ShowBlockTree