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 S M 2014/08/12 | Source: | Category: spid
Rating: |  Discuss |   Briefcase | 1,708 reads


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: | Category: sp_who2
Rating: |  Discuss |   Briefcase | 1,179 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: | Category: sp_who2
Rating: (not yet rated) |  Discuss |   Briefcase | 1,921 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: | Category: cursors
Rating: |  Discuss |   Briefcase | 1,339 reads
   Items 1 to 4 of 4   
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)