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.

Full-text working sporadically

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KEY - 07 Mar 2006 18:00 GMT
I have full-text running on one database only.  This index seems to have
issues about once every couple of weeks.  Normally, a search can be done (via
webpage) on a keyword - and it works fine.  But there are times that no
keyword (or other options) searches will work.  The only option that is
searchable is "records updated in the last x number of days".  So it's like
the full-text searching 1/2 works.

I have ran the stored procedure to ensure FTS was installed properly.
The MSSearch server is running under the local system account (as it should
be per MS).
I have deleted and rebuilt it complete.  I have tried to rebuild the index
via the wizard and by right-clicking on the Full-Text Catalog --- neither
fixed the issue.
I've ran the stored procedure to ensure it was enabled.  

Anyone have any idea why my FTS will work completely one day and work "a
little" the next?

Thanks!
Key
Hilary Cotter - 08 Mar 2006 02:27 GMT
Can you check the gatherer logs to see if they reveal anything?

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 have full-text running on one database only.  This index seems to have
> issues about once every couple of weeks.  Normally, a search can be done
[quoted text clipped - 19 lines]
> Thanks!
> Key
Simon Sabin - 26 Apr 2006 12:53 GMT
Do you have a schedueld rebuild. If so then at that point in time the index
won't return results.

Not sure what interface you are using because "records updated in the last
x number of days" is not a SQL full text query option.

> I have full-text running on one database only.  This index seems to
> have issues about once every couple of weeks.  Normally, a search can
[quoted text clipped - 18 lines]
> Thanks!
> Key
 
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.