SQL Server: sp_who2 to temp table

sp_who2_to_temp_table.sql

-- 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