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.
Subscribe to:
Post Comments (Atom)
1 comment:
Thanks, its working fine. i have been looking for a solution for past few weeks. Now its solved. Thanks once again...
Post a Comment