Browse by Tags

All Tags » cursors (RSS)

Cursor statuses

Here are the queries that findout the cursors based on their statuses 1 Find out the cursors that are allocated but not opened or closed --Method 1 select name from sys.dm_exec_cursors ( 0 ) where is_open = 0 --Method 2 select cur . cursor_name from sys...
Posted by Madhivanan | 1 comment(s)
Filed under: , ,