Characterize SQL SERVER (offending) processes for targeting will KILL {PID}

sql_process_characterization.sql

-- Characterize offending processes for targeting will KILL (pid)
Declare @T Table (SPID INT,
      Status VARCHAR(1000) NULL,
      Login SYSNAME NULL,
      HostName SYSNAME NULL,
      BlkBy SYSNAME NULL,
      DBName SYSNAME NULL,
      Command VARCHAR(1000) NULL,
      CPUTime INT NULL,
      DiskIO INT NULL,
      LastBatch VARCHAR(1000) NULL,
      ProgramName VARCHAR(1000) NULL,
      SPID2 INT
      , rEQUESTID INT NULL)
Insert @T EXEC sp_who2
SELECT DISTINCT(DBName) FROM @T
Select SPID  from @T