Re: Query Analyzer Erorr: Resource is low. Some results are dropped

From: Steve Kass (skass_at_drew.edu)
Date: 07/25/04 

Date: Sat, 24 Jul 2004 21:00:41 -0400

What exact build are you running (select @@version)?

This is a strange problem to see for a one-row result - it sounds like
the kind of thing that used to happen because of low GDI resources in
earlier versions of Windows, and it could have little or nothing to do
with Query Analyzer - any chance the problem is a video driver,
corrupted font file, or something similar (does changing the QA output
font or display resolution have any effect)? You could also try
changing the output display format to or from grid/text output, or
switch any other QA display settings, like whether windows are tabbed or
not. You might also see what resource utilization on the client looks
like from Task Manager.

If the problem persists after rebooting the client (and the server, if
practical), can you post the exact query, and say more about why you
think Office Clipboard has something to do with it?

Steve Kass
Drew University

TeaC wrote:

>Hi,
>
>I am using SQL Server 2000 SP3 on W2K SP4 with 1.5GB of RAM and 1.4GHz processor. When I get the error listed below, my processor utilization is <5% and only 500MB of RAM are used. I have been getting this error over the last several years on different machines/configurations/etc. It looks like several other folks have been getting this error message, but I haven't seen any resolutions to the problem. I believe the issue is on the client.
>
>When I use Query Analyzer on my server to either query the local SQL Server or a remote SQL Server, I get the same error:
>
>"Resource is low. Some results are dropped."
>
>My query is against a table with several thousand records, and when it works, it returns back a single record. (e.g., Select top 1 person, count(*) from color (nolock)
>group by person order by count(*) desc).
>
>I can get the error to go away, by shutting down every single application that's running on the box (e.g., IE, MS Office 2003, etc). I suspect that the problem is somehow related to the MS Office Clipboard.
>
>Any help would be greatly appreciated.
>
>
>

Relevant Pages

  • Re: bcp accent problem
    ... Query Analyzer would not display a binary value like ... Please run the command in Query Analyzer. ... with the file located on the Sql Server. ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Query Analyzer: displaying errors immediately
    ... how can I display all returned SQL Server errors ... SQL Server normally buffers output, and flushes the buffer when it ... it may be better to use text mode in Query Analyzer for this. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL2005 sys tables
    ... Maybe you don't have the SQL Editor toolbar open. ... You can also change the database context by using the USE statement in the ... SQL Server Documentation Team ... I mean in sql2000 query analyzer I can do the select statement against ...
    (microsoft.public.sqlserver.security)
  • RE: select during transaction**
    ... > in query analyzer I want to update ... beacuse sql server decide on clustered index scan, therefore this statement must wait on releasing locks made by UPDATE ... because sql server chose clustered index seek and it didn't touch/need ... the data locking by UPDATE from first window. ...
    (microsoft.public.sqlserver.programming)
  • Summing tables in a UDF
    ... developed in Sybase into a SQL Server UDF. ... to run call the function in Query Analyzer even though it ... declare rentrev integer; ... What UDF type do I need to recreate this in SQL Server? ...
    (microsoft.public.sqlserver.programming)