Highlight text replaced through theasurus file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 11 Nov 2008 17:03 GMT

I am using the FTS to run a search through an web application. (asp.net)
Is it possible to pickup that the theasurus file has replaced a search word
so that I can indicate this to the user via the website?
thanks.

Reply to this Message

Hilary Cotter - 19 Nov 2008 11:31 GMT

You will have to load the thesaurus file your self and parse it to make the
replacements. There is no mechanism provided by Microsoft which will tell you
which replacement/expansion term was used/replaced.

> I am using the FTS to run a search through an web application. (asp.net)
> Is it possible to pickup that the theasurus file has replaced a search word
> so that I can indicate this to the user via the website?
> thanks.

Reply to this Message

Simon Sabin - 18 Dec 2008 00:40 GMT

Hello Matt,

If Using SQL2008 you can use the sys.dm_fts_parser function

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> I am using the FTS to run a search through an web application.
> (asp.net)
> Is it possible to pickup that the theasurus file has replaced a search
> word
> so that I can indicate this to the user via the website?
> thanks

Reply to this Message