I've just discovered that the CONTAINS clause on sql2005 can search
multiple columns - great!
Is there a way to return which column the search word(s) were found in?
Dunc

If I open a SQL 2000 database using the management console the Full-Text
options are grayed-out / disabled...even though Full-Text search service is
started and I can create full-text catalogs using stored procedures in QA
and search using those catalog in QA.   This problem ...

I have a problem with a request concerning chineese data on a nText field...
Here is a sample:
TABLE : T
FIELD : TXT as nText

We have a SQL-Server 2000 DB with Full-Text-Search enabled on some of the
tables.
We have one table with about 15 million records. The table looks like

one of my customers moved a SQL Database from one server
to another. The database had 2 fulltext catalogs associated.
On the new DB Server the fulltext service doesn't start using
sp_fulltext_database 'enable'.

We are getting the dreaded "A clause of the query contained only
ignored words." error when a user searches for the following term:
"3.0" (without quotes).
I've checked all the noise word lists and "3.0" is not in there. "3" is

Hello, I have a full-text enabled field in my table has the following
content as an example:
"SQL Server is a comprehensive, integrated, end-to-end data solution
that empowers your people by providing a more secure, reliable, and

My understanding of full-text index searching is that CONTAINS()
requires that all the keywords supplied (separated by AND) must match
in the same column in order for the record to be considered a match and
returned. So if we have a situation where we need keywords to match in

I noticed that we were getting no results in our search this morning.
The records were in the DB, search terms matched when using "LIKE" but
not CONTAINS. Once I did a repopulation (incremental) all worked fine.
What I don't understand is that the repopulation is actually scheduled

I understand that full-text indexing is not available in the express
edition.
My situation is that we have to write an application to take advantage of
full-text-indexing when available.

I have Windows Server 2003 for Small Business Server. I am trying to
make the full-text searches work with Sharepoint. I initially didn't
have MSSearch installed so I went ahead and started the install for SQL
Server 2000 and selected the sharepoint instance of the database (which

I have a full text indexed xml column in sql server 2005 containing the
following xml snippet:
<plays>
       <folder id="681">

I cannot get Filtdump.exe to run. I have a server where MS SQL FullText
search is working perfectly (PDF, Office, HTML etc.) but when I run
FiltDump.exe on one of the PDFs I the following message:
C:\>temp\Filtdump.exe test.pdf

   Does anybody knows how to get the value for "ImpersonateClient" property
which is on IntegratedSecurity Object in SQL - DMO for SQL Server 2005
(Yukon).
   Documentation says that the functionality has been moved to "Server

i'm using SQL Server 2000 (SP3, I think).
i am looking at SQL for finding documents (table DOC) based on a couple of
criteria, one of which involves a fulltext index on a related table (TXT).
i discovered today that a less selective CONTAINS() clause: