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] Reference: http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/ Originally Posted on April 29, 2013Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code or program is ran…