"Eric Johnson" <ej@ejinnovations.com> wrote in message
news:FWuTg.63305$Db2.42115@fe09.news.easynews.com...
> I'm using SQL Express with Advanced Services and can't seem to get the
> FREETEXT or CONTAINS predicates to operate how they should. I've gone as
> far as create a simple database, with one table, with one column that's
> indexed and those still aren't returning anything other than direct hits.
>
> I have a table with 7 rows, all forms of the word 'ride' (taken from the
> sample in the documentation, which I'm assuming should work...):
>
> keyColumn string
> --------- ---------
> 1 ride
> 2 riding
> 3 ridden
> 4 rider
> 5 rides
> 6 riding freely
>
>
> "string" column is an nvarchar(255), keyColumn an identity int.
>
> Executing:
> select * from testtable where contains (string, 'formsof ( inflectional,
> ride )')
>
> just returns the first row above. According to the documentation, it
> should at least return a few others, right? The FREETEXT predicate
> returns the same way.
>
>
> SELECT FullTextCatalogProperty('TestFullTextCatalog', 'itemcount')
> SELECT FullTextCatalogProperty('TestFullTextCatalog', 'uniquekeycount')
> SELECT FullTextCatalogProperty('TestFullTextCatalog', 'indexsize')
> SELECT FullTextCatalogProperty('TestFullTextCatalog', 'populatestatus')
>
> Returns:
> 6
> 7
> 0
> 0
>
>
> What on earth am I doing wrong here?

"Eric Johnson" <ej@ejinnovations.com> wrote in message
news:451F3DEB.9060304@ejinnovations.com...
> I'm unsure how to check this.
>
> I did look at sp_configure and the Default Full Text Language is 1033 and
> Default Language is 0. I recreated the fulltext index on that simple
> table again, this time with TSQL and specifying "LANGUAGE 1033" and it
> worked. The documentation says that if the LANGUAGE clause is omitted
> that the server's Default Language would be used. But this doesn't seem
> to be the case. Am I going to have to recreate these indices all over,
> specifying the LANGUAGE ?
>
>
> Hilary Cotter wrote:
>> I suspect you are not using the US or UK English word breakers. Can you
>> verify which work breaker you are using?
>>

Hilary Cotter wrote:
> use sp_help_fulltext_columns and look at the FULLTEXT_LANGUAGE column value