Friday, March 30, 2012

Remove from noise list

how I can remove "c" from my noise word and how I rebuilt my catalog
to search on c#, c+, and c.
For SQL 2000 go to c:\Program Files\Microsoft SQL Server\MSSQL\Ftdata or
c:\Program Files\Microsoft SQL Server\MSSQL$InstanceName\Ftdata
For SQL 2005 go to
c:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Ftdata
Where X is your instance ID.
Edit the noise word list for your language, stop MSSearch (MSFTESQL in SQL
2005) save your changes and restart MSSearch or MSFTESQL.
Now you will be able to search on C#, C++ correctly, but no c++, or c#. It
must be uppercase in your content and queries to work.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Cenk FIRAT" <CenkFIRAT@.discussions.microsoft.com> wrote in message
news:4357CA5D-6A74-4161-B3E4-A007268B6DDA@.microsoft.com...
> how I can remove "c" from my noise word and how I rebuilt my catalog
> to search on c#, c+, and c.
>

No comments:

Post a Comment