Tìm những cursor đang được mở

SELECT
S.host_name AS ClientMachine
,S.program_name AS ApplicationName
,S.original_login_name AS LoginName
,C.name AS CursorName
,C.properties AS CursorOptions
,C.creation_time AS CursorCreatinTime
,ST.text AS SQLQuery
,C.is_open AS IsCursorOpen
,C.worker_time/1000 AS DurationInMiliSeconds
,C.reads AS NumberOfReads
,C.writes AS NumberOfWrites
FROM sys.dm_exec_cursors(0) AS C
INNER JOIN sys.dm_exec_sessions AS S
ON C.session_id = S.session_id
CROSS APPLY sys.dm_exec_sql_text(C.sql_handle) AS ST
ORDER BY DurationInMiliSeconds DESC
GO