SELECT c.session_id, c.properties, c.creation_time, c.is_open, t.text
FROM sys.dm_exec_cursors (52) c
CROSS APPLY sys.dm_exec_sql_text (c.sql_handle) t
More info: http://www.sqlskills.com/blogs/joe/hunting-down-the-origins-of-fetch-api_cursor-and-sp_cursorfetch/
FROM sys.dm_exec_cursors (52) c
CROSS APPLY sys.dm_exec_sql_text (c.sql_handle) t
More info: http://www.sqlskills.com/blogs/joe/hunting-down-the-origins-of-fetch-api_cursor-and-sp_cursorfetch/
No comments:
Post a Comment