T-SQL Monitor and Kill Process

## Create Temp Table and Insert Data to Table ##
CREATE TABLE #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 #sp_who2 EXEC sp_who2

## Select Data From Temp Table. You can use where condition ##

SELECT      * 
FROM        #sp_who2
WHERE       DBName <> 'master'
ORDER BY    DBName ASC

## Drop Temp Table ##
DROP TABLE #sp_who2



## Kill the Processes ##
Declare @SPID VARCHAR(5)
SET @SPID = '999'
EXEC('KILL ' + @SPID)