@zapcon, there is DMV
WHERE blocking_session_id <> 0;
master.sys.dm_exec_requests; DMV provides details on all of the processes running in SQL Server. With the WHERE condition listed below, only blocked processes will be returned.
as well as Stored procedure such as
sp_who; through you can identify the blocked
sp_who2 system stored procedure provides information about the current SQL Server processes with the associated users, application, database, CPU time, etc. The information returned can be filtered to return only the active processes by using the ‘active' parameter.
For your further Ref How to identify blocking in SQL Server