create proc [dbo].[sp_UC4_old_kill]
as
begin
if object_id('tempdb.dbo.quick_debug') is not null drop table tempdb.dbo.quick_debug

DECLARE @s VARCHAR(MAX)

EXEC sp_WhoIsActive 
    @format_output = 0, 
    @return_schema = 1, 
    @schema = @s OUTPUT

SET @s = REPLACE(@s, '<table_name>', 'tempdb.dbo.quick_debug')

EXEC(@s) 


EXEC sp_WhoIsActive 
    @format_output = 0, 
    @destination_table = 'tempdb.dbo.quick_debug'

--WAITFOR DELAY '00:00:05' 

select 'kill '+convert(varchar(8),session_id )+' --'+loginame,login_time
from tempdb.dbo.quick_debug,
sysprocesses
where session_id=spid and datediff(day,login_time,GETDATE())>0
return
end
--exec [sp_UC4_old_kill]