SQL Server - repost: SQL Server FT thesaurus file problem ..

Asked By Steve M

07-Nov-09 09:11 AM

Hi -

I am running SQL 2k5 Std Ed on Win XP Pro, current on SPs and patches.The
server collation is: SQL_Latin1_General_CP1_CI_AS

I tried to implement a minimal FT index Thesaurus file test:

create table FT_test (
FT_test_Id int identity(1,1) ,
theText varchar(8000)
)

insert	FT_test values('run')

CREATE FULLTEXT CATALOG [test]
IN PATH N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData'
WITH ACCENT_SENSITIVITY = OFF
AS DEFAULT
AUTHORIZATION [dbo]

CREATE unique CLUSTERED INDEX [idx_FT_test] ON [dbo].[FT_test] (FT_test_Id
ASC)

alter table FT_test add CONSTRAINT [idx_FT_test_PK] PRIMARY KEY NONCLUSTERED
(	FT_test_Id ASC	)

CREATE FULLTEXT INDEX ON [dbo].[FT_test](theText)
KEY INDEX [idx_FT_test] on [test] with CHANGE_TRACKING OFF , NO POPULATION

Alter Fulltext Index on [dbo].[FT_test] start Full Population

Then I altered the file:
tsENU.xml
in the path:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData

to read:

in a "SQL Server Enterprise Manager" "New Query" text pain.

Then, I restarted the "SQL Server FullText Search (SQL2K5)" in the

And now expect the following query should return 1 row:
select * from FT_test where contains(theText, 'jog')

instead it returns nothing.

Q1: What am I doing wrong ?
Q2: if I put a few hundred entries into a thesaurus file, will it noticably
slow either FT queries or FT crawls, on a production 8-way x64 server,
compared to not using the thesaurus files ?

Thanks for any assistance.

SteveM

07-Nov-09 09:10 PM

1) Thesaurus only works for freetext searches or formsof(thesaurus with
contains.
select * from FT_test where contains(theText, 'formsof(thesaurus, ''jog'')')

2) no.

19-Nov-09 08:29 AM

Hi -

Um, I tried the code you gave as an example:

select * from FT_test where contains(theText, 'formsof(thesaurus, ''jog'')')

, and it did not return anything. Clean boot, waited after giving the
population command, no error messages ..

I just re-tried it on a new clean db and new catalog. Same result.

???