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 |
|
hethy
Starting Member
8 Posts |
 Posted - 2002-08-24 : 14:28:49
|
| I've been getting this error from Query Analyzer when executing my SP:Resource is low, some results are droppedMy SP cursors through a Product table to get all the SKUs, then for each Product SKU it creates (and executes) a webtask -- @whentype=1.When I set the cursor (by changing the WHERE clause) to fewer (maybe less than 1000, the number isn't exact) records, the entire SP runs fine. When the cursor returns more than 1000-ish records, my SP runs, but inevitably will stop maybe after 5 minutes (which is how long it takes to run up to ~1000 iterations) with the popup message I mention above.I've been searching on the web for an answer to this question and found that although I'm not the only one who's asked it, no one seems to have found a satisfactory answer:[url]http://www.sqlmag.com/Forums/messageview.cfm?catid=5&threadid=5575[/url][url]http://www.sqlmag.com/Forums/messageview.cfm?catid=3&threadid=6442[/url]Any ideas what the "resource" is that the message is talking about? Is it SQL Server? my system? I'm using WinXP Pro and SQL Server 2K. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-08-24 : 22:31:42
|
| I would suspect that it is just your local machine. Query analyzer is having issues displaying all the returned info.Maybe turn nocount on in your procedure if it is there so it doesn't return so much to QA.Damian |
 |
|
|
|
|
|
In QA: Resource is low, some results are dropped