Hit Highlighting with SQl Servr 2008 FTS

Question

This question was here already but there was no answer, so trying one more time - how to do hit highlighting of results with SQL 2008 FTS?

So far I found SQLHighlighter but it is commercial product. I also tried solution described in this book http://apress.com/book/view/9781430215943 but performance was extremely poor. As last resort I tried Lucene.Net Highlighter, but it is linked with Lucene (which I'm trying to get away from).

Can someone recommend other way?

Thanks,

Antonin

Answer 1

AFAIK it is a listed 'bug' of FTS that it does not return any hit tracking information

You are left with parsing the query yourself, and matching that to each result rows text columns and doing the highlight

This could be quite simple or very hard depending on how you are building the FTS queries