Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I know this is ancient technology, but sometimes upgrading is not always an option.

Does anyone now how to list the actual noise words that are currently in use on a SQL 2000 Full Text Index?

We have a recurring problem on a very old SQL 2000 system. It is a 3 way Windows 2003 cluster. Once in a while the cluster fails over to a new node, and when that node comes online it seems to be using a different noise word list than what we want.

It seems that various service packs for SQL 2000 leave noise word files, and when the failover happens the first noiseword file found (in any directory) is the one that gets loaded.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

You are experiencing a known issue (where the default Windows noise.enu file is used instead of SQL Server's version). According to KB #889708, you need to copy the following registry key from the good node to the bad nodes:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ContentIndexCommon\LanguageResources\Override

Then you may still need to re-populate your FT indexes, not sure, and no 2000 instance handy to test, sorry. Also I don't believe there is any way to query the list of noise words (like you can on more modern versions).

share|improve this answer
    
That is what I was afraid of. –  datagod Jun 1 '12 at 20:18
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.