Is there a query or a method that can return the list of all the
indexed words in a column that has been full-text indexed in sql
server 2000? I need to get the words returned above in a
Containstable[] query on another column to get a rank that can suggest

I have create a Catalog and I am trying to find a record in the database that
satisfies the term: 102/3 or 102-3
These two terms works exactly the same way. The SQL searches for records
that have 102 or 3 in any position in the record, including in the middle of

Is there a way to ignore table locks when using the CONTAINSTABLE
statement ? Here is a code sample :
SELECT [KEY], RANK
FROM CONTAINSTABLE(MyTable, *, 'MySearchTerm') as S, MyTable

The following query works perfectly (returning all words on a list called
"Dolch" that do not contain a form of "doing"):
 SELECT 'Dolch' AS [List Name], dbo.Dolch.vchWord
 FROM dbo.Dolch LEFT OUTER JOIN

when i m searching with contains I want to ignore a character inside the
keyword,
Like
Es(ignore next char)ref

I have a database of students which contains a table StoredCvs. This
contains all of their CVs (Resume's) and has a full text index stored in a
"StoredFilesCatalog". It is unlikely that this table will grow to more than
1 million rows although it is possible.

I read in MSDN that
If the text and asterisk are not delimited by double quotation marks, as in
CONTAINS (column, 'text*'), full-text search considers the asterisk as a
character and will search for exact matches to text*.

Hi. I have a question - does anyone know on what criteria is the rank set by
FreeTextTable ? I created some records in the table "titles" containing the
words "drink", "much" and "abstinence" and.... well.... I can find no rhyme
or reason to the way this rank is established. I ...

How do I start the Search Service on my SQLServer 2000 on winxpsp2 ?
I have installed it, but in the Service Manager I see only
DTC
OLAP SERVICE

I need to do a freetext-search on multiple columns in the same table,
searching with the same keywords.
For example
WHERE FREETEXT({col1, col2}, "searching for this")

I am implementing a full text search. When I search for the word 'is', it is
giving a wrong result. I need the help to solve this problem.

I have a simple FT query
SELECT PK,TEXT_DATA
FROM TABLE
WHERE CONTAINSs(TEXT_DATA,'"search1" and "search2"')

We are debating whether it is a good idea to store large documents (on the average over 100 MB - max size currently at 220  MB) in SQL server itself OR to strip the document of the "noise" words outside of sql server and store just the words we need to be indexed.
We are ...

Hi
I am receiving the error "query contained only ignored words" from the word
"best" that is not in the ignored words list.  While researching the problem
online I found the following link:

Does anyone have experience with Full Text catalogs on large tables? We
have a full text catalog on a table with about 30 million rows. Acording
to BOL, once you get over 1 million you'll need to make some
adjustements. Our system works, but often we get the following errors