allen,

thanks for your time.

fyi...SPID -2 is assign to all orphan connections, where the client has somehow disconnect from SQL Server and Windows abnormally.

just decided to see if i give back to the SQL Server community, so please be gentle on my response.

Here is where i think you can start looking at with...

-2 in the req_spid field.

I can't find any more information in the BOL other than brief description on each attribute in the syslockinfo table.

sp_who2 tells me the blocker SPID is -2, so i get to the syslockinfo the get a list of all orphan transactions.

The question is which one if there are more...