Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GIDMEISTER
Starting Member
1 Post |
 Posted - 2010-04-09 : 14:29:04
|
| My website is on a shared server. It uses a sql server database that is on a third shared server.I want to do a full-text search. I can't locate the noise word file, because I assume the shared host company would not divulge where it is. I need to be able to remove noise words from some of my search phrases before using them.I can't use 'sp_configure' to automatically replace noise words by asterixes, because I think would apply to many databases at once, and therefore would mess up other users.Is there any way to query the noise word file to find out if it has a particular word? |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-04-09 : 15:10:05
|
| http://support.microsoft.com/kb/905617 that file is located at$SQL_Server_Install_Path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
noise words in full text search