sql:sql_server_see_sessions_and_running_queries

SQL Server Sessions and running queries

SELECT
	SessionId           = ses.session_id
	,[Database]    = DB_Name(er.database_id)
	,[Login]            = ses.login_name
	,Host               = ses.host_name
	,StartTime          = er.start_time
	,ClientAddress      = con.client_net_address
	,SQLStatement       = st.text
FROM sys.dm_exec_requests er
OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) st
LEFT JOIN sys.dm_exec_sessions ses ON ses.session_id = er.session_id
LEFT JOIN sys.dm_exec_connections con ON con.session_id = ses.session_id
WHERE ses.is_user_process = 0x1
--AND ses.session_id != @@SPID
ORDER BY
    ses.session_id