Article ID: 2513181 - View products that this article applies to.
In Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 when indexing a XML column using full-text only node values and attribute values for the top node are indexed. Attribute values for any of the inner nodes are not indexed.
This behavior happens because the XML word breaker that is shipped with SQL Server 2008 and SQL Server 2008 R2 does not return attribute values for any of the inner nodes (xmlfilt.dll - Version: 12.0.9735.0).
This issue can be resolved using the XML word breaker that ships with Windows operating system when SQL Server is running on either Windows 7 or Windows Server 2008 R2 (version shipped with Windows use different file name - xmlfilter.dll). If you are running SQL Server on a lower version of Windows, you first need to upgrade to these operating systems and then use the following procedure to resolve this issue.
Procedure to resolve the problem on SQL Servers running on Windows Server 2008 R2 and Windows 7 environments:
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base: 322756
(http://support.microsoft.com/kb/322756)(http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows
Note: You need to restart SQL Server Service after going through the following procedure for the changes to come into effect.
Steps to repro:
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2513181 - Last Review: July 13, 2011 - Revision: 3.0
Contact us for more help
Connect with Answer Desk for expert help.