Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / April 2006

Tip: Looking for answers? Try searching our database.

FTS returns no results

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Doug Batchelor - 28 Apr 2006 20:33 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.