Re: Too many results error

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the response Simon. Do you know what the upper limit is within
2005, if indeed there is one?

Regards,
Steve

"Simon Sabin" wrote:

Hello Equality72521,

SQL 2005 has a very different architecture to SQL 2000 so more rows can be
managed


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


Thanks for your input Daniel.

I've just noticed that the error doesn't occur on SQL 2005, and there
doesn't appear to be a 20000 row limitation; the same CONTAINS query
that returns zero rows in SQL 2000 returns all rows in SQL 2005.

Thanks again.

Steve

"Daniel Crichton" wrote:

Equality72521 wrote on Thu, 28 Jun 2007 02:16:03 -0700:

Hi Hilary, thanks for replying.

The query I used was as follows (generic field / table placeholder
used):

SELECT <field1> FROM <table1> WHERE CONTAINS(<field1>, ' "AZ*" ')

I was away from the office yesterday and interestingly, when I run
the exact same query today, I don't get the error - I also get no
results back, which is in keeping with the fix I believe. Perhaps
the error was related to the index being built in the background as
I was attempting the query?

This seems to be contrary to the fix, which is supposed to throw the
error message according to
http://support.microsoft.com/default.aspx?scid=kb;en-us;296456

The fix for SQL2K has been present since SP2.

There are definitely results that should be returned; when I run a
LIKE query I get 102998 rows returned:

The above URL suggests that this error will fire when there are more
than around 20,000 results, so getting an error with that many
results would be expected.

Dan




.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Populating a list -- learning Access
    ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL! ... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)