• Jonathan,

    I've received the below for the blocked process:

    <inputbuf>

    Proc [Database Id = 14 Object Id = 1311948665] </inputbuf>

    </process>

    This is a stored procedure that doesn't touch the table that was being blocked. Could this indicate that: the blocked process report only shows the last executed query of a multi-query batch or transaction?

    How else can a table be blocked by a SP that has nothing to do with it?