We were getting errors when users searched for the term "r&d" - with or
without quotes - so we removed all single-letter words from the noise
word files (.eng, .enu and .dat). We then started Microsoft Search
again and did a full population - "rebuild" was grayed out.

I keep receiving these on SQL server (2000, SP3a) that my SharePoint is using:
One or more documents stored in image columns with extension 'doc' did not
get full-text  indexed because loading the filter failed with error '0x1'.
Note:  These documents will  not be passed to ...

I'm trying to use a SQL Server 2005 with WSS (Sharepoint Services). I try to
index the files in the WSS however this just doesn't work. I have set the
full-text in Sharepoint & the service in SQL Server 2k5 is installed and
running.

As has been mentioned several times in this group, SQL Server does not
support a leading wildcard in full text searches (i.e., CONTAINS(field,
'*tion')).
To get around this I have been looking at external full text search

We have a Windows Sharepoint Services installation and are indexing its
content. I have a question regarding the index so I thought it might be
better to post here instead of the WSS newsgroups.
Anyway, here we go:

I am working on a system where we wish toc reat a full text catalog in sql server 2000. I created a test catalog and started a 'full population' but it failed. After several attempts I restarted the 'Mircosoft Search' service and it is failing with the following error:
"The ...

I am performing full-text-search on a table containing word documents
in it's column. The search  results fair when a single word is
searched. i.e. when I fire the following query:
     select * from docs where contains(document, '"java"');

I copied a database. Then I need to delete full text catalog and
re-create one with exact same name. But it doesn't let me drop it. The
machine just hangs there forever when I try to drop it. So I read
through the usenet and found a way to delete it from

Got a bizarre problem
In our search box, someone types in the search term:
   A$
This results in the PARTIAL SQL:

Sorry if this is an FAQ...
I have a column of text and a bit column. Is there a recommended approach to
searching the text where the bit=1?
Thanks Soc.

I would like to select rows containing some text which is more than one word.
The problem is that the text can appear in different colums, meaning, one
word in this column and another in that. moreove, I need to select only the
rows containing all the words.

i have problem in fulltex search, when i search any
english word it give me perfect result.
In my table i have define fulltext search on a column
name content_html, data type of column is ntext it

Hi. I'm connecting to a database on SQL Server 2000 SP3 on which I'm the
dbo. However, when I right-click any of the tables, it has the "Full-Text
Index Table" item grayed out. Is this only available to members of the SA
group on the server? Thanks.

I am getting this error message from SQL Server when attempting any full-text
catalog operation:
Error 7619: Execution of a full-text operation failed. The parameter is
incorrect.

    I am working on a project and need some help. I am having an
application that uploads the data in the "resume" table and the content
of resume table is as follows:
<pre>