Thesaurus on full-text search is not working

Hi all, here's my setup:

Sql Server 2005 on Windows Server 2003 (standard). I have a datbase (Sql 90
compatibility level). I have very trivial example set up to try to get the
thesaurus to work.

My table:
CREATE TABLE TestData
(
TestDataID int PRIMARY KEY NOT NULL IDENTITY(1, 1),
TestData varchar(max) NOT NULL
)
go
-- the data:
insert into TestData(TestData) values('book')
insert into TestData(TestData) values('article')

Ok, so I create a full-text index on this table/data, then modify my
thesaurus file (tsEnu.xml) to this.
<XML ID="Microsoft Search Thesaurus">
<expansion>
<sub>book</sub>
<sub>article</sub>
</expansion>
</XML>

Then I re-start the Sql Server and Sql Full text services. Then I issue the
following query:
select * from ContainsTable(dbo.TestData, *, 'FORMSOF(THESAURUS, book)')

and it returns ONLY the key and rank of the row with 'book' in it. Using
FileMon from sysinternals, I can see that the tsEnu.xml and tsGlobal.xml are
queried by the msftesql.exe process (upon running the query) making me think
they should be working.

I have tried many combinations of the data, query syntax (like adding
dbl-quotes around book etc.) but there is no result of the expanded (or in
the cases I tried it a replacement).

Can someone offer some insight into how to troubleshoot this?

Thanks!
Richard Lowe


.

Relevant Pages

  • Re: Thesaurus on full-text search is not working
    ... the thesaurus to work. ... TestData varcharNOT NULL ... Then I re-start the Sql Server and Sql Full text services. ... are queried by the msftesql.exe process (upon running the query) making me ...
    (microsoft.public.sqlserver.fulltext)
  • whats wrong w/ my queries?
    ... from MPWork as a, TestData as b ... Behold the above query! ... When run using the two small tables above, the query runs ...
    (microsoft.public.sqlserver.programming)
Loading