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 - 2000-09-16 : 20:39:12
|
Tiffany writes "I'm trying to optimize some code of mine by putting the database query into a stored procedure and I keep running into problems. I can create the sp and execute it on the server fine. When I go to execute it in the old asp (that worked just fine with a plain old SQLstmt = "bunch of SQL stuff. . .") I get an error 800a0007 Out of memory in line 93 of my code.
I'm redim-ing a bunch of variables to the record count returned by the sp. Could this be the problem?
I'm running NT with option pack 4 and SQL 7.0"
|
|
|
|
|
|
Out of Memory errors with Stored Procedures