MSSQL - List Running SQL Process

The script below lists all running sql and its session_id.  Use session_id to kill the process.

-- List running processes
DECLARE @DatabaseName VARCHAR(50) = DB_NAME()
SELECT * FROM MASTER.dbo.SysProcesses WHERE DBId = DB_ID(@DatabaseName)


-- List SQL for running processes

SELECT

     sqltext.TEXT

    ,req.session_id
    ,req.status
    ,req.command
    ,req.cpu_time
    ,req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

KILL [session_id]