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.