Remove from noise list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cenk FIRAT - 26 Oct 2006 10:30 GMT

how I can remove "c" from my noise word and how I rebuilt my catalog
to search on c#, c+, and c.

Reply to this Message

Hilary Cotter - 26 Oct 2006 15:20 GMT

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.

Signature

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

> how I can remove "c" from my noise word and how I rebuilt my catalog
> to search on c#, c+, and c.

Reply to this Message