finding the blocks in sql server

By Paarthasarathy, 2013/06/19

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 following

SPID OF RUNNING APPLICATION
APPLICATION NAME
EXECUTING DATA
BLOCKED (Y/N)
BLOCKING SPID
BLOCKING APPLICATION
EXECUTING DATA (BLOCKING APPLICATION)

The Procedure's target version is SQL SERVER 2000.
If u have something to say on this, pls leave ur comments either in my blogspot or mail me.

Total article views: 3455 | Views in the last 30 days: 13

FORUM

SP_PREPEXEC and SP_UNPREPARE blocking

BLOCKING

FORUM

Blocking Stored Procedures

I need to block access to a stored procedure

FORUM

blocking

FORUM

blocking

how long it is blocking

FORUM

how to run stored procedure from C# application

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

finding the blocks in sql server

SP_PREPEXEC and SP_UNPREPARE blocking

Blocking Stored Procedures

blocking

blocking

how to run stored procedure from C# application

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: