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 |
|
khufiamalik
Posting Yak Master
120 Posts |
 Posted - 2008-10-16 : 07:08:27
|
| how to find that how many Cursors are still open????? |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-10-16 : 07:29:47
|
This should get you startedDECLARE @report CURSOREXEC sp_cursor_list @report OUTPUT, @cursor_scope = 3FETCH NEXT from @ReportWHILE (@@FETCH_STATUS <> -1)BEGIN FETCH NEXT from @ReportENDCLOSE @ReportDEALLOCATE @Report -------------Charlie |
 |
|
|
|
|
|
finding open Cursors ?