Two ways to find out the current running query:
First Query
SELECT s.session_id,
Db_name(r.database_id) AS dbname,
s.login_name,
r.blocking_session_id AS blkby,
r.open_transaction_count,
r.status,
s.host_name,
s.program_name,
r.command,
(SELECT Substring(TEXT, statement_start_offset / 2, (
CASE
WHEN statement_end_offset = -1 THEN Len(
CONVERT(NVARCHAR(MAX), TEXT)) * 2
ELSE statement_end_offset
END statement_start_offset ) / 2 )
FROM sys.dm_exec_sql_text(sql_handle)) AS querytext
FROM sys.dm_exec_sessions s
JOIN sys.dm_exec_requests r
ON s.session_id = r.session_id
WHERE r.session_id = 57 -- SPID
First Query
SELECT s.session_id,
Db_name(r.database_id) AS dbname,
s.login_name,
r.blocking_session_id AS blkby,
r.open_transaction_count,
r.status,
s.host_name,
s.program_name,
r.command,
(SELECT Substring(TEXT, statement_start_offset / 2, (
CASE
WHEN statement_end_offset = -1 THEN Len(
CONVERT(NVARCHAR(MAX), TEXT)) * 2
ELSE statement_end_offset
END statement_start_offset ) / 2 )
FROM sys.dm_exec_sql_text(sql_handle)) AS querytext
FROM sys.dm_exec_sessions s
JOIN sys.dm_exec_requests r
ON s.session_id = r.session_id
WHERE r.session_id = 57 -- SPID