I have a query
SELECT DISTINCT Top 400 PFSchemaInstance_ID, 0 Rank, 0 CriteriaCount,
FromDate, pfSchemaInstance_ID FROM
PFLightningSearch_PersonProfileImpulse_Publish L WHERE CONTAINS (Text,
'"s*"') Order by FromDate desc, pfSchemaInstance_ID desc

And I know the Text column contains strings with words that begin with s,
but it returns no records.

I've checked that the entry for the FTS index in sysfulltextcatalogs is
correct and I've run:
sp_fulltext_catalog 'FTSindexName', 'rebuild'

What can be wrong with my FTSIndex ?

It has worked at one point.

can you issue this query in your database you are full text indexing?

SELECT fulltextcatalogproperty('Cat_Desc', 'ItemCount')

Where Cat_desc is the name of your full text catalog?


--
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

[quoted text, click to view]

Allan,
What error did you get when you executed the below query? A clause of the
query contained only ignored words? or no results from your query? If the
latter, have you removed all single letters from your language-specific
noise word file? Note, noise.enu = US English.

Additionally, have you run a Full Population after you did the rebuild?
"Rebuild" - Rebuilds fulltext_catalog_name by deleting the existing
full-text catalog from the file system, re-creating the full-text catalog,
and reassociating the full-text catalog with all the tables that have
full-text indexing references. Note, rebuild does not re-populate the FT
Catalog, so you will also need to run a Full Population.

Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/


[quoted text, click to view]

[quoted text, click to view]

SELECT fulltextcatalogproperty('PFLightningSearch_Publish', 'ItemCount')

Returns 0

[quoted text, click to view]

No results werer returned from the query, actually there is nothing returned
nomatter what I search for, even longer words that I know exist in the text
(ie. "jobtype*").

[quoted text, click to view]

I've done a "Start Full Population" on the Index and now it works!!
Can I put the "start full population" into a SQL script?

Kind Regards,
Allan Ebdrup