sql server full text search: I'm implementing the search features on a web site.
If I search for several words not in the noise file everithing is ok.
If I search with several words and only one of it is in the noise file
the query fails with

Execution of a full-text operation failed. A clause of the query
contained only ignored words.

Why say me that the clause contain only ignored words???

This is the query:


SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
"window"')
SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
"window"')

Thanks a lot for your help!!

Andrew,
This is a common question on this newsgroup and one that can be workaround,
via either client-side or server-side solutions. As for the text of the
message, I agree that it is badly written as most often the query will not
contain only noise words, but in fact one or more depending upon how the
search words are specified in the search condition.

I'd recommend that you review SQL Server 2000 BOL title "Full-text Search
Recommendations", and KB article 246800 (Q246800) "INF: Correctly Parsing
Quotation Marks in FTS Queries" at
http://support.microsoft.com//default.aspx?scid=kb;EN-US;246800 (with T-SQL,
JavaScript, & VBScript coding examples) and search this newsgroup for
SearchPage.htm (or SearchPage.zip) for server-side and client-side solution
of removing the noise words before issuing a SQL FTS query.

Hope this helps!
John




[quoted text, click to view]

"From" is considered to be a noise word and can trigger this error. The best
approach for smaller tables you are Full Text Indexing is to empty the
contents your noise word list and replace it with a single space.

To do this go to a command prompt and type net stop MSSearch and press enter

Go to go to c:\Program Files\Microsoft
SQLServer\mssql\ftdata\sqlserver\config. Then edit the noise.enu (for US
English) in notepad, press ctrl and A, and then press the space bar. Then
select File and Save.

Then restart MSSearch.

You should then do a full population.


--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
[quoted text, click to view]