SDU Tools 22 Show Current Blocking in SQL Server
SDU Tools are a free set of T-SQL tools (Registration is required) to help developers and database administrators (DBAs) working with SQL Server.
This video shows how to use a procedure lists locks being held and queries that are blocking or being blocked, for a given database.
You'll find more info about SDU Tools and download details at http://www.sqldownunder.com/Resources...