How to remove noise words from SQL server?
• Check the language of your sql using following syntax
select @@languagee.g. result : us_english
• Now here you have “English language” so…• Remove required word from following files…
1. the noise.* files under your \WINNT\System32 directory
2. noise.enu (US_English) and noise.eng (UK_English) noise word files under your SQL Server default folder of \FTDATA\SQLServer\Config.
• After making these changes and before saving the file changes, you must stop the “Microsoft Search“ service, before you can save the FTDATA noise word files. When your modifications are completed, you must run a Full Population.
Enjoy.
Thursday, June 21, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment