Get Active Queries In SQL Server 2008
In this article I tell you about how to get list of active queries in SQL Server.
In this article I tell you about how to get list of active queries in SQL Server.
To get active queries using T-SQL, run following code snippet:
SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle)
This code will generate following result:
