Error in FTS

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
"Allan Ebdrup" <comaeb@.ofir.com> wrote in message
news:uc5Ft0zcFHA.2696@.TK2MSFTNGP09.phx.gbl...
>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.
>
|||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/
"Allan Ebdrup" <comaeb@.ofir.com> wrote in message
news:uc5Ft0zcFHA.2696@.TK2MSFTNGP09.phx.gbl...
> 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.
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23FTskf0cFHA.796@.TK2MSFTNGP09.phx.gbl...
> 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?
SELECT fulltextcatalogproperty('PFLightningSearch_Publish ', 'ItemCount')
Returns 0
|||"John Kane" <jt-kane@.comcast.net> wrote in message
news:%236akLB3cFHA.3032@.TK2MSFTNGP10.phx.gbl...
> 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.
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*").

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