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-04 : 08:48:26
|
| Eric writes "Please excuse me if this is covered elsewhere on your site. I was unable to find anything on this topic.I've been led to believe that there is a "limitation" in SQL Server that prevents it from creating a server-side scrollable cursor for use by a client when using stored procedures that do *anything* other than issue a select statement. This means no output parameters, no SET statements, no calling other procedures, etc. Is this the case? Is there something that I can do to configure my SQL Server to allow this?I believe this assertion is correct because I have some stored procedures that not only use output parameters, but also call other procedures for logging purposes, etc. I have never been able to get a scrollable cursor in my client code. Am I totally misusing SQL Server?Any help would be much appreciated. Thank you for your time!SQL Server version: Microsoft SQL Server 2000 - 8.00.194Operating System: Microsoft Windows 2000 5.00.2195 Service Pack 4Regards, Eric" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-04 : 08:50:43
|
quote:
Am I totally misusing SQL Server?
IMHO any use of a cursor in SQL Server is a misuse. Especially returning one from a stored procedure.It's better if you describe what you're trying to accomplish rather than how you want to accomplish it. It's likely you don't need cursors to do what you want, and in that case the problem would simply disappear. |
 |
|
|
|
|
|
Scrollable cursors from stored procedures