SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag SPID Rss

Search for any content tagged spid

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)

Add a script

   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: SQLServerCentral.com | Category: spid
Rating: |  Discuss |   Briefcase | 1,764 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: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 1,195 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,939 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,348 reads
   Items 1 to 4 of 4