Re: Too many full-text columns or the full-text query is too compl

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

The problem is there are too many words beginning with n. To get results for
such a query you should try to restrict the search somewhat, ie na*, or nb*,
etc.

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"OLAPFOREVER" <OLAPFOREVER@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:653EADB0-5A82-4342-A12D-6B6278F43114@xxxxxxxxxxxxxxxx
the problem is not de noise world list because
all other letter work well

I seach for all words begin by N
all others tests with A* B* C* ... Z* returns results or nothing (no
row)
but N* retrurn the Msg 9937 Error message

"Mohit K. Gupta" wrote:

I am sorry. Anyhow, are you trying to find words like 'Anything' or
words
like 'Nothing'.

N* will not catch Anything because it is not a prefixed, it will only
catch
Nothing. I couldn't get it to ignore 'Nothing'.

I highly douht it but you can check the noise world list.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005


"OLAPFOREVER" wrote:


select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' )
Col1, Col2 , and Col3 are the Fts Indexed Columns and I search for N*
is it must clear ?



"Mohit K. Gupta" wrote:

Hmmm is that the right query?

Doesn't look right, try:

For One search...

SELECT *
FROM Table1
WHERE CONTAINS(FTSField, ' "N*" ');

Multi-Search ...

SELECT *
FROM Table1
WHERE CONTAINS(FTSField, ' "A*" OR "N*" ');

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005


"OLAPFOREVER" wrote:

Msg 9937, Level 16, State 5, Line 1
Too many full-text columns or the full-text query is too complex to
be
executed.

HI

When I search for that in FTS I got this error
select * from Table1 where contains (a,b,c),'"n*"' )
but if I seach for a*, b* or z* all its ok just n* cause
problem

I try to reorganize the catalog with alter fulltext catalog
ftcatalog
reorganize
and alter fulltext catalog ftcatalog rebuild but the probleme
appear again

could you help me ?



.

Relevant Pages