SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-SQL » cursors (RSS)

Browse by Tags

  • 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.syscursorrefs as ref inner join sys.syscursors...
    Posted to Madhivanan (Weblog) by Madhivanan on Tue, Sep 8 2009
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems