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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-20 : 07:13:27
|
| Jorge79mx writes "I am looking for the way to find ALL the CURSOR Open in ALL the Conections, i try with select * from master..syscursors, but only return my own CURSOR into the connection.thankz :)" |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2005-01-20 : 14:29:56
|
| evenselect * from master..syscursors (nolock)does not work! really interesting........ |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-20 : 18:54:31
|
Well, the only other solution I can think of is...STOP USING CURSORS, and then you won't need to find the open ones.  Wouldn't it be cool if you could DENY permission on the DECLARE CURSOR command? |
|
|
|
|
|
|
SQL SERVER CURSOR OPEN