Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-01-16 : 00:14:55
|
| hi how to find all open cursor detail in sql2005thanks |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-16 : 03:03:08
|
| If you mean a specific cursor , try the CURSOR_STATUS , e.g SELECT CURSOR_STATUS('global','<my_curor_name>'). This will resturn certain values dependant on the state of the cursorIf you are interested in cursors across different databases , the sys.dm_exec_cursors returns useful informationJack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-01-18 : 03:03:41
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2009/09/08/cursor-statuses.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Find open cursor detail in sql2005