Post reply

Query Analyzer Error: resource is low. Some results are dropped

  • September 9, 2005 at 9:11 am

    #168721

    I am receiving the following error in query analyzer - resource is low, some results are dropped... I know that a large stored prochedure is being run when I get the error.

    Any ideas?

    Doesn't make sense to me as the server is: win 2003, dual xeon 3ghz, w/ 3 gig ram.

  • September 9, 2005 at 9:42 am

    #588763

    I usually get this when I have a query/procedure in an endless loop, and I stop it.

    Does this procedure return tons of data within a loop?

    Make sure your code is functioning properly

  • September 9, 2005 at 11:38 am

    #588824

    If your SP has loops and you enabled to show execution plan, you can easily run into this situation.

     

  • September 21, 2005 at 5:23 am

    #591667

    Had the same problem with batch queries that would have  select.... statements in. Set your execute mode to [Results to text] and run your code again.

  • September 21, 2005 at 8:16 am

    #591788

    This error is ussually caused due to a MASSIVE number or records returned to the Client side. Please either Limit the number of records returned or increase the RAM of your client computer

     


    * Noel

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply