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

Blogs

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Do Full Backups Break Log Shipping?

By

TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...

Daily Coping 15 Oct 2021

By

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

Read the latest Blogs

Forums

Disabling all access to the server

By Alex John

Hello everyone! We have a small group of users (4) using MS Access 2000...

How to remove data and index fragmentation in a table

By 892717952

The picture is showing the results that I used sp_spaceused for OldTable and NewTable,...

Database Recovery but DB is 7GB and log file is almost 3

By Vector

I have had a server crash and although I was able to recover the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers