SQL 2008 full text break text pointers

SQL Server 2008 does not seem to support searching for offset pointers by keywords found in the memo field.

Full-text search does not search the fields of notes, but looks for an index that indicates which keywords are in which documents. Information about where these words appear in each document does not appear to be available in the full text search index.

Microsoft offers a query like sys.dm_fts_index_keywords_by_document. With it, you can enable the following use cases:

"I want to know how many keywords the full-text index contains"

"I want to know if a keyword is part of a given doc/row"

"I want to know how many times a keyword appears in the whole full-text index"  (sum(occurrence_Count) where keyword=……)

"I want to know how many times a keyword appears in a given doc/row"

"I want to know how many keywords a given doc/row contains"

"I want to retrieve all the keywords belonging to a given doc/row"

      

        
        
        
      

    

However, scenarios not covered in this release:

"I want to know the offset (word or byte) of a given keyword in this document / line"

"I want to know the distance (in words) between two keywords for a given document / line"

Sources:

http://technet.microsoft.com/en-us/library/cc721269.aspx#_Toc202506233

http://msdn.microsoft.com/en-us/library/cc280607.aspx