A quick script to enable you to find the processes that are blocking in SQL server
-
Updated
Sep 25, 2024
#
sql-server-2008
Here are 4 public repositories matching this topic...
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...
-
Updated
Sep 25, 2024
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.
database-management-system sql-server-performance windows-software sql-server-2008 sql-server-2008-sp1-download sql-server-2008-latest-version sql-server-2008-free sql-server-stability
-
Updated
Sep 10, 2026
Add this topic to your repo
To associate your repository with the sql-server-2008 topic, visit your repo's landing page and select "manage topics."