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
Download SQL Server 2008 — a database management system for Windows with free download. Manage your data efficiently with advanced query optimization and Visual Studio integration. Ideal for small projects. Grab your free copy today.
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."