Noise Words

http://msdn2.microsoft.com/en-us/library/ms345119.aspx explains nicely how to
get SQL Server to ignore noise words in the query, BOL's discussion on noise
words is all nice except things don't seem as they appear.
Right from BOL:
Important:
If you edit a noise-word file, you must repopulate the full-text catalogs
before the changes will take effect.
Yes, the DBA has a choice in the matter. No, wait...I made changes,
repopulated the index, and I'm still not getting the results I want.
There are words in the $SQL_Server_Install_Path\Microsoft SQL
Server\MSSQL.1\MSSQL\FTDATA\ noise files that I don't agree with as noise
words. When I remove them and repopulate the index, I still get tagged for
"Informational: The full-text search condition contained noise word(s)."
Is there a literal difference from words of BOL "repopulate the full-text
catalogs" and the context menu item "Start full Population"? I know I must
be overlooking something. Can I seriously edit the noise words, or is it a
tease?
-DanPlease forgive me, I did discover that rebuilding the Catelog is much
different than repopulating the indexes. Maybe the BOL could differentiate
this better since Index manuveres can be achieved thru context menus and
catelogs have to be rebuilt via a ALTER FULLTEXT CATALOG statement. not
real clear in the docs
-Dan
"Dan Davis" wrote:
> http://msdn2.microsoft.com/en-us/library/ms345119.aspx explains nicely how to
> get SQL Server to ignore noise words in the query, BOL's discussion on noise
> words is all nice except things don't seem as they appear.
> Right from BOL:
> Important:
> If you edit a noise-word file, you must repopulate the full-text catalogs
> before the changes will take effect.
> Yes, the DBA has a choice in the matter. No, wait...I made changes,
> repopulated the index, and I'm still not getting the results I want.
> There are words in the $SQL_Server_Install_Path\Microsoft SQL
> Server\MSSQL.1\MSSQL\FTDATA\ noise files that I don't agree with as noise
> words. When I remove them and repopulate the index, I still get tagged for
> "Informational: The full-text search condition contained noise word(s)."
>
> Is there a literal difference from words of BOL "repopulate the full-text
> catalogs" and the context menu item "Start full Population"? I know I must
> be overlooking something. Can I seriously edit the noise words, or is it a
> tease?
> -Dan|||Hi Dan
There is a .fulltext newsgroup. You might have better luck posting your
questions there.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Dan Davis" <In_Finite@.news.postalias> wrote in message
news:9F9E5E9A-1A7F-484A-98B3-E3E8F5C95F27@.microsoft.com...
> Please forgive me, I did discover that rebuilding the Catelog is much
> different than repopulating the indexes. Maybe the BOL could
> differentiate
> this better since Index manuveres can be achieved thru context menus and
> catelogs have to be rebuilt via a ALTER FULLTEXT CATALOG statement. not
> real clear in the docs
> -Dan
> "Dan Davis" wrote:
>> http://msdn2.microsoft.com/en-us/library/ms345119.aspx explains nicely
>> how to
>> get SQL Server to ignore noise words in the query, BOL's discussion on
>> noise
>> words is all nice except things don't seem as they appear.
>> Right from BOL:
>> Important:
>> If you edit a noise-word file, you must repopulate the full-text catalogs
>> before the changes will take effect.
>> Yes, the DBA has a choice in the matter. No, wait...I made changes,
>> repopulated the index, and I'm still not getting the results I want.
>> There are words in the $SQL_Server_Install_Path\Microsoft SQL
>> Server\MSSQL.1\MSSQL\FTDATA\ noise files that I don't agree with as noise
>> words. When I remove them and repopulate the index, I still get tagged
>> for
>> "Informational: The full-text search condition contained noise word(s)."
>>
>> Is there a literal difference from words of BOL "repopulate the full-text
>> catalogs" and the context menu item "Start full Population"? I know I
>> must
>> be overlooking something. Can I seriously edit the noise words, or is it
>> a
>> tease?
>> -Dan