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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  problem calling stored procedure

Author  Topic  ian19 Starting Member 6 Posts Posted - 2001-07-01 : 11:48:56 Im using SQL SERVER 7 I have a stored procedure that executes perfectly when i run it from the query analyzer. But when i call it from the asp page, it does nothing. I've tried drilling down the contents of the stored procedure, the problem seemed to be on the cursor part(i use 1 cursor to loop through a table), it doesn't seem to perform the loop. what could i do about it?