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 - 2003-10-29 : 08:20:42
|
| YH writes "Hi,I called stored procedure which has CURSOR using ADO in ASP script. The problem is whenever I called this stored procedure, the CURSOR is stoped after selecting several records. But if I execute this stored procedure in the SQL Server directly, I can get over 100 records.Do you guys have any idea to solve this problem?Many thanks" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-29 : 09:21:25
|
| Maybe if you post the stored procedure and how execute it from each method might help us.Any error handling in the stored procedure?Cursors just don't stop...and why are you using a cursor?Brett8-) |
 |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-10-29 : 09:28:25
|
| Not sure but maybe:create procedure ...asset nocount on |
|
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2003-10-29 : 09:50:13
|
| some code please...Daniel Small MIAPwww.danielsmall.com IT Factoring |
|
|
|
|
|
|
SQL CURSOR