SQLServerCentral.com Scripts tagged sp_who2

Capture and Alert for Blocked SPIDS with SP_WHO2

Wed, 06 Apr 2011 06:00:00 UT

This will capture locked/blocked spids and alert with the inputbuffer info as well as the login info. Then email it and record the history of the blocks.

usp_who5

Thu, 25 Aug 2011 06:00:00 UT

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.

View connection and Locking Information

Mon, 17 May 2010 06:00:00 UT

This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

usp_SQL_In_sp_who2

Fri, 24 Apr 2009 06:00:00 UT

Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID

Indepth SPID information

Fri, 09 Jan 2009 07:00:00 UT

This SP gives you most of the detail you need on a long running query. Simply pass the SPID.