
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
> We're using SQL Server 2005 service pack 1. It was my understanding that
> FreeTextTable automatically includes inflectional forms. We're not able
[quoted text clipped - 4 lines]
> Thanks,
> Krip
Hilary,
Nope, not wrapping with double quotes. Here's the clause:
INNER JOIN FreeTextTable(myTable, myField, 'tests') as FTT
I have 'test' in the data but 'tests' doesn't find it. That's just one
example (fox works but not foxes; landed works but not landing).
The following doesn't work either:
SELECT *
FROM myTable
WHERE CONTAINS(*, 'FORMSOF (INFLECTIONAL, foxes)')
Also, I've now installed SP2 and rebuilt the catalag - same issue.
Is there some place to enable inflectional forms? Or is there a dictionary
to populate?
Thanks,
Krip
Hilary Cotter - 23 Feb 2007 18:19 GMT
Perhaps it is a language issue, what does this return? sp_configure 'default
full-text language'

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
> Hilary,
>
[quoted text clipped - 18 lines]
> Thanks,
> Krip
Krip - 23 Feb 2007 19:00 GMT
Hilary,
It returns the following:
name: default full-text language
minimum: 0
maximum: 2147483647
config_value: 1033
run_value: 1033
Thanks for your help,
Krip