sp_who2 returns
SPID --> which is the process under consideration
BLK --> if it has a value represents the SPID of the blocking process
Ex. SPID =10 BLK=51 --> Process 10 is being blocked by process 51
sp_lock return all process request or in lock states unless the status is grant state.
-- Returns information about currently active lock manager resources.
select * from sys.dm_tran_locks
---- [font="Tahoma"]Live and Let Live![/font] ----