How to get the list of processes which are blocked in SQL SERVER?

Answer:

There are two ways to get this sp_who and sp_who2. You cannot get any detail about the sp_who2 but its provide more information than the sp_who. And other option from which we can find which process is blocked by other process is by using Enterprise Manager or Management Studio(SSMS), these two commands work much faster and more efficiently than these GUI-based front-ends.