Technical Article

finding the blocks in sql server

Hai buddies,The following procedure can be used to find whether there are any blocks in the sql server.The procedure if run in Master database , can be used like any other system stored procedure from any database.The output of the proc will contain the followingSPID OF RUNNING APPLICATIONAPPLICATION NAMEEXECUTING DATABLOCKED (Y/N)BLOCKING SPIDBLOCKING APPLICATIONEXECUTING DATA (BLOCKING […]

3.67 (3)

2007-09-09

3,551 reads

Blogs

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Getting a list of the articles in a publication.

By

The other day I was asked to supply a list of all of the...

Daily Coping 17 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SSRS permissions basics

By cb122

Is it possible via a query, specific to 'SSRS' (SQL Server Reporting Services) to...

Azure SQL Database Differential Backup Frequency

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Azure SQL Database Differential Backup...

The General Database Platform

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The General Database Platform

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers