You're welcome, Craig,
Yes, (MSFTESQL$SQL90 - for my named instance: SQL90), hopefully (and in this
area especially), the Yukon based documentation will improve over the SQL
Server 2000 BOL entries on FTS! Post your example when your can.
Yes, an easier way to make changes, additions and deletions to the Xml
Thesaurus files either via a GUI or even a command line tool would be most
helpful! I would even go so far as to say for true production-level use of
these Xml Thesaurus files to be effective, a method of extracting keywords
from the SQL table's FT-enabled text and then relating these terms to their
synonyms, antonyms, hypernyms and "Related Terms" is required to provide
true thesuraus functionality. Then one could use the extracted keywords and
related terms to update the Xml Thesaurus files and I have several ideas on
how to achieve this as well.
I suspect that this may be outside the scope of tasks to be completed in
order to ship SQL Server 2005 on time and with high quality & reliability,
but I hope that something like both of these tools could developed and
released as a sample app &/or in the Resource Kit...
Stay in touch,
John
> Hi John
>
[quoted text clipped - 54 lines]
> > >
> > > Craig
Craig - 17 Dec 2004 13:59 GMT
Hi John
So I guess Sql Server 2005 release will not have the functionality to read
and write the thesaurus files via an API. I can write this class as well,
it'll be serialized and require prehaps a .config to enable alternate install
locations of the files. When I'm done, I'll post them back to the news group.
After updating the thesaurus file, does the MSFTESQL service require a
re-start for the updates to take effect?
Craig
> You're welcome, Craig,
> Yes, (MSFTESQL$SQL90 - for my named instance: SQL90), hopefully (and in this
[quoted text clipped - 87 lines]
> > > >
> > > > Craig