Skip to content

Instantly share code, notes, and snippets.

@rysstad

rysstad/sp_who2_to_temp_table.sql

Created May 22, 2015 14:02
Show Gist options
  • Save rysstad/5a8db5bf1b9510c1b1e7 to your computer and use it in GitHub Desktop.
Save rysstad/5a8db5bf1b9510c1b1e7 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. rysstad created this gist May 22, 2015.
    20 changes: 20 additions & 0 deletions sp_who2_to_temp_table.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,20 @@
    -- MS SQL Server: sp_who2 to temp table
    CREATE TABLE #temp_sp_who2 (
    SPID INT,Status VARCHAR(255),
    Login VARCHAR(255),
    HostName VARCHAR(255),
    BlkBy VARCHAR(255),
    DBName VARCHAR(255),
    Command VARCHAR(255),
    CPUTime INT,
    DiskIO INT,
    LastBatch VARCHAR(255),
    ProgramName VARCHAR(255),
    SPID2 INT,
    REQUESTID INT
    )
    INSERT INTO #temp_sp_who2 EXEC sp_who2
    SELECT * FROM #temp_sp_who2
    WHERE DBName <> 'master' AND DBName <> 'msdb'
    ORDER BY DBName ASC
    DROP TABLE #temp_sp_who2