Here's an alternate version that doesn't use sp_who yet provides a little more information. It also provides the option to kill the blocking processes themself.IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ListBlocking]') AND type in (N'P', N'PC'))EXEC...
A quick script to enable you to find the processes that are blocking in SQL server
SQL Server 2008 SP1 is a free full-version database management software for Windows that enhances stability and performance, integrates better with PowerShell, and supports ClickOnce technology. Download the latest version free.
To associate your repository with the sql-server-2008 topic, visit your repo's landing page and select "manage topics."