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 |
|
Jim.J
Starting Member
5 Posts |
 Posted - 2002-09-03 : 09:22:35
|
| Hi all,I want to use Full-Text Index for vancancy listings on a job portal. However the problem is one of the most common search terms is "IT". A Freetext search on "IT" causes errors as it is an ignored word. Anyway to get SQL Server to accept it? or any other work around?Thanks. |
|
|
lozitskiy
Starting Member
28 Posts |
Posted - 2002-09-03 : 09:29:37
|
| BOL:Noise-word lists for many languages are provided in the directory \Mssql\Ftdata\Sqlserver\Config. This directory is created, and the noise-word files are installed when you set up Microsoft® SQL Server™ with the full-text search support. The noise-word files can be edited. For example, system administrators at high-tech companies might add the word computer to their noise-word list. (If you edit a noise-word file, you must repopulate the full-text catalogs before the changes will take effect.)-------------MCP MSSQL |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-03 : 11:39:10
|
| Be aware that if you are on Windows 2000 then you also need to remove the word from noise.xxx in winnt\system32Which file you edit depends on the language settings you are using on your server. You need to stop the MSSearch service before editing the files.HTHJasper Smith |
|
|
|
Jim.J
Starting Member
5 Posts |
Posted - 2002-09-03 : 11:53:55
|
Thanks,but.. Im using a web hosts SQL Server so no access to sys files  Any work around? |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-03 : 13:56:45
|
| Not in terms of stopping it being a noise word. You can remove it from your search phrase on the client or server however that would not be much help.Another option would be to expand IT (or I.T.) to Information Technology when vacancy's are entered or searched on - bit of a fiddle though.HTHJasper Smith |
|
|
|
Jim.J
Starting Member
5 Posts |
Posted - 2002-09-03 : 15:21:03
|
| Ye thanks,I thought about that, just a bit worried about the overhead of the replace statements.Back to the drawing board ;( |
|
|
|
|
|
|
Full-Text problem