I am trying to get FTS to work on an SQL Express (Advanced) database. I have
a table with a unique index(int), a column type field (nvarchar(15)) which I
set to "Image" and a word document field (Image). I set up the catalog and
the full-text index and verified that both are running OK. When I tried to
run a search with CONTAINS, no results were returned, just the field headers.
I ran the following:
use prostaff
go
select FULLTEXTCATALOGPROPERTY('ResumeCat','ItemCount')
go
Returned 5
select FULLTEXTCATALOGPROPERTY('ResumeCat','UniqueKeyCount')
go
Returned 0
select FULLTEXTCATALOGPROPERTY('ResumeCat','PopulateStatus')
go
Returned 0
select FULLTEXTCATALOGPROPERTY('ResumeCat','IndexSize')
go
Returned 0
I would appreciate any help on this - thanks in advance
Hilary Cotter - 29 Apr 2006 16:44 GMT
It looks like 5 rows have been indexed, but no text was found in these rows.
What do the gatherer logs reveal.

Signature
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
>I am trying to get FTS to work on an SQL Express (Advanced) database. I
>have
[quoted text clipped - 27 lines]
>
> I would appreciate any help on this - thanks in advance
Doug Batchelor - 30 Apr 2006 18:33 GMT
I found the problem. I messed up with the filter. I was inserting "Image"
into the filter type instead of ".doc"
> It looks like 5 rows have been indexed, but no text was found in these
> rows. What do the gatherer logs reveal.
[quoted text clipped - 31 lines]
>>
>> I would appreciate any help on this - thanks in advance