USE Northwind
GO

EXEC sp_who2
GO

CREATE PROC mySproc99
AS
  BEGIN
	DECLARE @SPID int, @cmd varchar(255)

	CREATE TABLE #myTemp99 (
		  SPID int
		, Status varchar(50)
		, Login varchar(255)
		, HostName varchar(50)
		, BlkBy char(10)
		, DBName varchar(255)
		, Command varchar(50)
		, CPUTime int
		, DiskIO int
		, LastBatch varchar(50)
		, ProgramName varchar(50)
		, SPID2 int
	)
	
	INSERT INTO #myTemp99 EXEC sp_Who2
	
	SELECT @SPID = MAX(SPID) FROM #myTemp99 WHERE SPID > 50

	SELECT @cmd = 'KILL ' + CONVERT(varchar(15),@SPID)
	EXEC(@cmd)

	DROP TABLE #myTemp99
  END
GO

EXEC mySproc99
GO

EXEC sp_who2
GO

DROP PROC mySproc99
GO