Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    7

    Question Unanswered: Resource Is Low,some Results Are Dropped

    hello, I need help!

    I had the Query Analyser give me this message "Resource is Low, some
    results are dropped" when I tried executing a Stored Procedure.
    The stored procedure uses a cursor and it reed 5000 registers.

    Can anyone help me please?

    Thanks

  2. #2
    Join Date
    Jan 2007
    Posts
    1
    1. In query analyzer

    2. Go to Query menu

    3. Select "Result in Text"

    4. Execute the query.
    Let me know if this works....


    Thanks
    Sandesh S
    http://sanssql.blogspot.com/
    http://sanssql.googlepages.com/

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Ctrl+T - results to text
    Ctrl+D - results to grid
    Ctrl+Shift+F - results to text file

    But I think the problem you're describing relates to too many resultsets being returned by your stored procedure when they are sent to grid in QA. Are you sure the app front-end is expecting 5000 resultsets from it?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •