Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

finding the blocks in sql server

By Paarthasarathy,

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: 3517 | Views in the last 30 days: 9
 
Related Articles
FORUM
FORUM

Blocking Stored Procedures

I need to block access to a stored procedure

FORUM

blocking

blocking

FORUM

blocking

how long it is blocking

FORUM

how to run stored procedure from C# application

how to run stored procedure from C# application

 
Contribute