there is no full thesaurus. Basically many people would be upset if they
started getting unexpected results coming back in their searches. So MS
hands you a sample and has you customize it.
You can find it at C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\FTData

Signature
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
> How can I get and install a full Thesaurus into SQL Server 2005 CTP?
>
> Thanks in advance!
>
> Wayne
wkbia - 22 Jul 2005 02:26 GMT
That's a lot of work; can't expect a developer to be a grammer grad as well.
It would be nice if they supplied a full English thesarus that could be put
online and modified as needed as I think more people are upset that they are
not getting the results they expect from a thesarus search, this is why
they're doing it. Inflectional searches seem to be fully functional and
releasing a full-text thesarus search should be fully functional as well.
I think I seen a post from you stating that you could get a thesarus from
Word. Is this true and if so, can you tell me how I can obtain and install it.
Thank you Hilary. I seen a lot of replies from you and I'm sure there are
many who appreciate that you are doing this as I do.
With best regards,
Wayne
> there is no full thesaurus. Basically many people would be upset if they
> started getting unexpected results coming back in their searches. So MS
[quoted text clipped - 8 lines]
> >
> > Wayne
Hilary Cotter - 22 Jul 2005 03:27 GMT

Signature
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
> That's a lot of work; can't expect a developer to be a grammer grad as well.
> It would be nice if they supplied a full English thesarus that could be put
[quoted text clipped - 25 lines]
> > >
> > > Wayne
wkbia - 23 Jul 2005 04:47 GMT
I tried updating the tsENG.xml file but can't seem to get a thesaurus search
to return a result other then the key word. car returns car, auto returns
auto. Can you recommend anthing?
The query:
SELECT name
FROM dbo.categories
WHERE freetext(name, 'car')
SELECT name
FROM dbo.categories
WHERE contains(name, 'FORMSOF(THESAURUS, "car")')
Niether query works.
Here's the xml file.
<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
<sub>Internet Explorer</sub>
<sub>IE</sub>
<sub>IE5</sub>
</expansion>
<replacement>
<pat>NT5</pat>
<pat>W2K</pat>
<sub>Windows 2000</sub>
</replacement>
<expansion>
<sub>run</sub>
<sub>jog</sub>
</expansion>
<expansion>
<sub>car</sub>
<sub>auto</sub>
</expansion>
</thesaurus>
</XML>
Thanks again.
> there is no full thesaurus. Basically many people would be upset if they
> started getting unexpected results coming back in their searches. So MS
[quoted text clipped - 8 lines]
> >
> > Wayne
Hilary Cotter - 23 Jul 2005 11:52 GMT
this is the list for UK English, I think you want tsENU.xml as you seem to
be in AZ.
I tried your xml file and it works for me.

Signature
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
>
> I tried updating the tsENG.xml file but can't seem to get a thesaurus search
[quoted text clipped - 56 lines]
> > >
> > > Wayne
wkbia - 24 Jul 2005 18:39 GMT
I actually found this out after my post. I also just found out that you need
to use the language argument in the sp_fulltext_column procedure as it
doesn't default. Dropping the argument, the procedure seemed to execute
correctly as there was no warning, but it hadn't.
Got it working now... Thank you.
Wish I had a somewhat complete thesarus though, or at least one that I could
modify. Do you or anyone else no where I could get one and preferably free
since I have no capitol at this time.
Thanks again and in advance.
Wayne
> this is the list for UK English, I think you want tsENU.xml as you seem to
> be in AZ.
[quoted text clipped - 61 lines]
> > > >
> > > > Wayne