Too many full-text columns or the full-text query is too complex

Too many full-text columns or the full-text query is too complex

Post by T0xBUEZPUk » Sat, 07 Jul 2007 23:16:03


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 ?
 
 
 

Too many full-text columns or the full-text query is too complex

Post by T0xBUEZPUk » Sat, 07 Jul 2007 23:18:04

Im run under SQL Server 2005 sp2

 
 
 

Too many full-text columns or the full-text query is too complex

Post by TW9oaXQgSy » Sun, 08 Jul 2007 02:58:01

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