Full text search not working though Full-Text Catalogs are available

Full text search not working though Full-Text Catalogs are available

Post by Girish Raj » Fri, 27 Aug 2004 09:02:25


We have a SPS 2003 installation on our network with SQL Server 2000(Full
text search installed).

The problem is that, when I search for a term say 'California' in the home
page, I get only two results (Lists).
But there are a lot of docs that has 'California' within it but are not
present in the search results.

Our full-text catalog on the site DB seems good as it has total of 71941
Items, 258027 unique keys and 26 MB of content.

To test the full-text catalog, I ran the following query,
"select count(*) from Docs where contains(content,'California')"
and the query gave me a result of 119.

I am wondering why those 119 documents didn't show up in the search results.

Also under,
Site Settings > Configure Search and Indexing >Include file types,
doc,pdf, ppt are all included but they don't show up in the search results.

Has someone encountered this before?
Any help would be greatly appreciated.

Thank you,
-Girish Raja.
 
 
 

1. Full-text query failed because full-text catalog 'SIMCatalog' is not yet ready for queries.

2. Carrying out a full-text search, but without the full-text search...

Hi everyone.

I have a fairly simple question, but the answer is likely to be very
complex. I would like to create a wiki that will allow full-text
searches. However, as you know, full-text searches in a large database
is very CPU intensive. I need to look into what options are available
in the way of breaking everything down into keywords, and how I'd do
it efficiently. I know that there is no definitive answer to my query,
but I have no idea where to start looking. I would like to make my
wiki very much like a small-scale search engine. Much like Google, but
far, far smaller by comparison.

Google doesn't just do a full-text search on the several billion pages
it has stored every time you make a query. They evidently have some
algorithm running behind it all which breaks everything down very
efficiently indeed.

I would very much appreciate it if anyone could point me in the right
direction, with any suggestions, whether thy be logic, documents I
should read, or terms I can Google.

Thanks in advance.

Daz.

3. Full-Text Search is not installed, or a full-text component ca

4. Full-Text Search is not installed, or a full-text component cannot

5. Unknown full-text failure (8007007e) occurred in function EnumCatalogs on full-text catalog

6. Help - An unknown full-text failure (80004005) while trying to create a new full-text catalog

7. Options for generic full-text search without using database-specific full-text engine?

8. MSDE2000 Full-Text Indexing & Full-Text Search (FTS)

9. Project 2003 and Full-Text Search / Full-Text Index

10. Full-Text Search not available

11. full text search not working for multilingual text

12. Too many full-text columns or the full-text query is too complex

13. Too many full-text columns or the full-text query is too compl

14. Can I see what is inside Full-Text Search Catalog?