In SQL Server 2012, the ability was added for full-text search to search on PROPERTY values. However, there is no way to retrieve the property value in question. The actual entire property value should be emitted by the parser and available in a DMV or side table. For example:Suppose I have three documents that have authors of "Bob Beauchemin", "Bob Newhart" and "Bob Gupta". I can do a CONTAINS-based search for documents with authors that have a keyword "Bob", but can't bring back the entire propery value, which would be very useful.Currently, the closest I can get is using sys.dm_fts_index_keywords_by_property. But think only produces the keywords, not the property values. So, in the case above, I wouldn't know if the actual author name was "Bob Newhart" or "Newhart Bob". And keywords wouldn't include noisewords.Since this could produce a lot of additional data, perhaps it could be a full-text index option.
Product Language
Category
Proposed Solution
Primary Benefit
Other Benefits
Virtualization