• I think you mis-pasted the results there. You should see a session_id. I know you can identify the blocked session id. From that, you look at the wait_type column to see what it is waiting on. You'll probably also see the blocking_session_id. Use that to see what the other session is doing. With the wait information (like the deadlock at the top of what you have pasted, that's not good) and the blocking session's ID, you can figure out what's preventing you from moving forward.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning