The full-text search results that are returned in a clustered SQL Server 2000 environment may be different when the active node changes (889708)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)




Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

When you perform a full-text query in Microsoft SQL Server 2000 in a clustered environment, the search results that are returned may be different when they are returned from the second node in the cluster.

CAUSE

This problem occurs when the noise word file location is not replicated between the nodes in the cluster. When SQL Server 2000 is installed in a cluster, the registry keys that contain the location of the noise word files are only created on the primary node from which the SQL Server 2000 Setup program was run. Therefore, when the second node becomes the active node, the Microsoft Search (MSSearch) service no longer points to the correct set of noise word files.

WORKAROUND

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To work around this problem, you must export and then import the following registry key from the first node to the second node in the cluster:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ContentIndexCommon\LanguageResources\Override

To do this, follow these steps:

Steps to export the registry key on the first node

  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then click the following registry key:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ContentIndexCommon\LanguageResources\Override

  3. On the File menu, click Export.
  4. In the File name box, type OverrideFileName where OverrideFileName is the name of export file, and then click Save.
  5. On the File menu, click Exit.
Note When you save the export file, save the file to a location that the second node can access.

Steps to import the registry key to the second node

  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. On the File menu, click Import.
  3. In the Import Registry File dialog box, select the exported <OverrideFileName> file name, and then click Open.
  4. Click Ok to the confirmation, and then on the File menu, click Exit.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about full-text queries and noise word files, visit the following Microsoft Developer Network (MSDN) Web site:

Full-Text Catalogs and Indexes

Modification Type:MinorLast Reviewed:3/18/2006
Keywords:kbtshoot kbprb KB889708 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.