"tshad" <tscheiderich@ftsolutions.com> wrote in message
news:eqyfTSskFHA.4000@TK2MSFTNGP12.phx.gbl...
> I was testing my system and found the following error when I entered only
> words, such as "The":
>
> Execution of a full-text operation failed. A clause of the query contained
> only ignored words.
>
> Now I understand that it may not find anything out there as it is not
going
> to search for every document with these types of words, but why would that
> give me an error?
>
> I would assume I would get no results.
>
> How do I test for this beforehand? Obviously, some people are going to
> enter these types of words periodically and I don't want this error
> displaying.
>
> Thanks,
>
> Tom
>
>

"tshad" <tscheiderich@ftsolutions.com> wrote in message
news:eqyfTSskFHA.4000@TK2MSFTNGP12.phx.gbl...
> I was testing my system and found the following error when I entered only
> words, such as "The":
>
> Execution of a full-text operation failed. A clause of the query contained
> only ignored words.
>
> Now I understand that it may not find anything out there as it is not
going
> to search for every document with these types of words, but why would that
> give me an error?
>
> I would assume I would get no results.
>
> How do I test for this beforehand? Obviously, some people are going to
> enter these types of words periodically and I don't want this error
> displaying.
>
> Thanks,
>
> Tom
>
>

"John Kane" <jt-kane@comcast.net> wrote in message
news:uSR2BJxkFHA.3316@TK2MSFTNGP14.phx.gbl...
> Hi Tshad,
> First of all, could you post the full output of -- select @@version -- as
> this will help in understanding your environment.
> Secondly, this is a frequently asked question on this newsgroup and there
> are several workaround &/or alternatives to this issue with SQL Server 7.0
> or SQL Server 2000.
>
> You can use a client-side app to "filter" or remove the noise words from
> the
> user's input string prior to submitting the SQL FTS query to SQL Server.
> You
> can also use FREETEXT or FREETEXTTABLE as these FTS predicates are more
> forgiving in this regard than CONTAINS or CONTAINSTABLE. Additionally, you
> can use phrase and double quotes to have the CONTAINS query truly ignore
> the
> "noise word. For more details on this see, SQL Server 2000 BOL title
> "Full-text Search Recommendations" as well as the following Kb article
> 246800 (Q246800) "INF: Correctly Parsing Quotation Marks in FTS Queries"
> at
> http://support.microsoft.com//default.aspx?scid=kb;EN-US;246800 for more
> info.
>
> Furthermore, you can edit the noise word files under the
> \FTDATA\SQLServer\Config directory where you have SQL Server installed.
> The
> files noise.* where * is the language extension, such that noise.enu =
> US_English, noise.eng = UK_English. NOTE: you can empty the file of all
> words, but you should leave at least one space character in the file as
> there are bugs, if you remove all text from these files! You can open
> these
> files with notepad and edit them, but to save the files, you must stop the
> "Microsoft Search" (mssearch) service first and then save the file and run
> a
> Full Population.
>
> Hope that help!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
>
> "tshad" <tscheiderich@ftsolutions.com> wrote in message
> news:eqyfTSskFHA.4000@TK2MSFTNGP12.phx.gbl...
>> I was testing my system and found the following error when I entered only
>> words, such as "The":
>>
>> Execution of a full-text operation failed. A clause of the query
>> contained
>> only ignored words.
>>
>> Now I understand that it may not find anything out there as it is not
> going
>> to search for every document with these types of words, but why would
>> that
>> give me an error?
>>
>> I would assume I would get no results.
>>
>> How do I test for this beforehand? Obviously, some people are going to
>> enter these types of words periodically and I don't want this error
>> displaying.
>>
>> Thanks,
>>
>> Tom
>>
>>
>
>