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,531 reads

Blogs

Updated Pluralsight Course – Managing the Kubernetes API Server and Pods

By

My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...

Daily Coping 11 May 2021

By

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

What do you do when technology changes? : T-SQL Tuesday #138

By

Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...

Read the latest Blogs

Forums

Copy value from one row to another if column matches

By bent

Hi there, I just don't get it. Need to update rows in same table....

virtual phone

By alanyeka

virtual phone A man was going to the house of some rich person. As...

Does lastBatch in sp_who2 really mean the time the user execute a SQL batch

By sqlfriend

I usually use sp_who2 see who is connected and is active in the SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers