Could corrupt data cause Error #7643 ("Too many results") ??

I'm trying to execute this search on a table containing approx 80K records
and am getting this error: Server: Msg 7643, Level 16, State 1, Line 7
Your search generated too many results. Please perform a more specific search.

Facts:
- My search string is '("18-1/2" or "18-1/2IN*" or "18-1/2FT*" or "18-1/2x*"
or "x18-1/2*") and formsof(inflectional, "valley")'
- I'm using a ConstainsTable statement.
- There are only about 10 records that match the search string, so the error
is definitely not accurate.
- It appears that the culprit is "1/2". Specifically, if I change the "1"
in "1/2" to another number (ex 2/2, 0/2, 3/2, etc) I don't get the error.
- Also, if I take out any two of the conditions with asterisks in them (ex
18-1/2x*and 18-12IN*") I don't get the error.
- I can execute this query on any of our other servers that have the same
versions of SQL & OS and do not get the error on them.
- Also, the Noise Word files for all of these servers are empty.

Here is the SQL & OS version information:
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Could this error be caused by corrupted or unusual data in this particular
table on this particular server??? Thanks for any help.
Tim
.

Relevant Pages

  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)
  • Re: Opinions on approach, please...
    ... Create a data layer program per table, ... number of bind variable tokens in your dynamic SQL. ... then simply EXECUTE that without passing it any parameters? ... Hard code WHERE clauses. ...
    (comp.lang.cobol)
  • RE: permissions compatible with pre-Win2000 servers
    ... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
    (microsoft.public.windows.server.migration)
  • Re: Performance Monitor / Database Storage using ODBC
    ... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Injection- Bypassing magic_quotes
    ... Because i was trying to execute: ... Don't terminate the query and you most ... Or try something like bobcat or one of the other SQL injection tools out ... Chief Information Security Officer ...
    (Pen-Test)
Loading