How to view current cursor activity

[k108]

Is there a way to view current cursor activity on a database?

I could have sworn there was sp_helpcursor, but there isn't.

Thanks!

 

[mrdenny]

Is this what you are looking for?

exec sp_cursor_list 3

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[vongrunt]

sp_cursor_list expects cursor variable to pass results back (OUTPUT argument). This sometimes kind of sucks, so for quick checks you can dig into master db and use:

SELECT CR.reference_name, CR.cursor_scope, C.*
from master..syscursorrefs CR 
inner join master..syscursors C on CR.cursor_handl=C.cursor_handle

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)