Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SPID Rss

   Items 1 to 4 of 4   
 

Simple script to list out SPID, Program_name and login details

If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.  Read more...
By Sourav Mukherjee 2014/08/12 | Source: SQLServerCentral.com | Category: spid
Rating: |  Discuss |   Briefcase | 1,252 reads

usp_SQL_In_sp_who2

Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID  Read more...
By Banyardi Schmardi 2009/04/24 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 1,155 reads

Indepth SPID information

This SP gives you most of the detail you need on a long running query. Simply pass the SPID.  Read more...
By Amar P 2009/01/09 | Source: SQLServerCentral.com | Category: sp_who2
Rating: (not yet rated) |  Discuss |   Briefcase | 1,889 reads

DB Connection Killer

This script opens a little cursor that will clean out connections to any DBs you specify.  Read more...
By Miguel Pereira-543757 2008/09/09 | Source: SQLServerCentral.com | Category: cursors
Rating: |  Discuss |   Briefcase | 1,325 reads
   Items 1 to 4 of 4   
 
Tags
sp_who2 (2)    
blocking (1)    
cursors (1)    
input buffer (1)    
program_name (1)    
sys.dm_exec_query_plan (1)    
sys.dm_exec_requests (1)    
sys.sysprocesses (1)