I am trying to set up a search query for users that just put in words with
no "AND"s or "OR"s.  I am curious if it is better to put "AND"s or "OR"s in
places where the user doesn't specifically specify it.
For example:

I'm trying to understand the benefit of using an FTS Inverted Index
in the context of the following example:
Given a set of articles, I want to retrieve a subset that matches
certain keywords.

Hi, I need to search a product catalog for an online store, users must be
able to search for kitchens with "4" burners, but I get this error : "A
clause of the query contained only ignored words", below is the code for
stored procedure I'm using. Before I send the "@SearchTerms" ...

How can I test from Windows, using the registry or APIs or ... that
Full-Text Search is installed on a SQL box?
I want to confirm during an application install that FTS is present.
I want to perform the test at the operating system level, not through SQL

I have a test development database with a single table, which contains over
2 million rows. To check performance of fulltext vs index query, I enabled
FullText on the database. The fulltext index runs for few hours, after that
event viewer throws lots of (around 500) error ...

I've got SQL2000 Enterprise edition running on windows 2000 advanced server,
we've recently upgraded from SQL sp2 to sp3a, this caused a catalog rebuild
but full population is taking forever. The column with Full text search
enabled is of image type, there are 2.5 million record ...

I get the error message: "Unknown full-text failure (8007007e) occurred
in function EnumCatalogs on full-text catalog" when trying to create a
new full-text catalog in SQL Server 2000 Developer SP3 (on XP Pro SP2).
The same database under SQL Server Personal (on Windows 2000) works

I've been using FTS for 5 years now on 1.5million rows of data. Certain
things have alway annoyed me about it however:
1. I never managed to succesfully move/copy ft catalogs.
2. Noise words/symbols/single characters e.g. c#, c#, "I am not".

Can someone tell me which is better to say in QA:
Use Database
Go
EXEC sp_fulltext_catalog 'catalog_1', 'Rebuild'

I am new to full text search and researching on implementing FTS on failrly
complex XML documents with HTML elements embedded into it.
Is it possible to achieve this in a fairly working manner? If so what do i
need to do.

I have built a functioning full text search tool on my companies
extranet site.  I use the containstable function.  I was curious what
the syntax or process would be to do a "without these words" box to
allow users to filter their search results better.

Is there a way to specify which column weights more when doing full text
search..
For example, I have three column, filename, description and data.  I did
full text index on all three column, but want to list the hits in filename

I am trying to do the following query
select * from privateSearchFT
where contains
(*,'"formsof(inflectional,produce)" OR

Why do I get the error:
System.Data.SqlClient.SqlException: Syntax error occurred near 'clerk'.
Expected ''''' in search condition 'Benefits clerk'.
I get this from:

I have 2 full text catalogs, and one of them (sometimes both) goes to pause
status occasionally. I suspect this occurs during a backup.
I checked the status of the Microsoft search service and it states that it
is "started", but I've found that restarting the service unpauses the