Symptoms
When you enable full-text index for a document that contains an email hyperlink at the start of a paragraph and no trailing whitespace at the end of the previous paragraph in Microsoft SQL Server 2012, full-text does not index the contents of the hyperlink correctly, and no error is raised in the full-text log file.
Resolution
The issue was first fixed in the following cumulative update of SQL Server.
Note To enable the feature, you have to add a new DWORD value "IncludeLinkInfo" in the following location for the corresponding SQL instance in the register:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.< instanceName >\MSSearch Name: IncludeLinkInfo
Type: REG_DWORD
Value: 1
You can set the value to 0, or delete this DWORD value to disable the feature.
Cumulative Update 3 for SQL Server 2012 SP2 /en-us/help/3002049
Cumulative Update 12 for SQL Server 2012 SP1 /en-us/help/2991533
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
