How to run Microsoft full-text Search service on a separate
machine(otherthanSQLServer)
Is it possible to create Microsoft Search Service for full-text search
on separate machine instead of running it on SQL Server machine? If so,

Hi
We are running full text search with 4GB RAM on SQL server 2000. Ihave the
/3G option on in boot.ini. The VM setting is  set at 2048 to 4095.
I read it in the manual that the optimal configuration for full text search

Is that normal??
I am populating my catalog, and i see the catalog size growing 45MB,
47MB, 52MB..1MB
and suddenly it goes to zero and starts again

When I look at properties for FT in cluster administrator the only owner I
see is the node1 owner.  Why doesn't owner node2 show up as a selection?
I'm thinking about doing the following below from a MS KB article to fix my
problem, any ideas?

this is a new windows 2003 server/sql server 2000 set up (2-3 days old).
full text is set up and working and definetely added data, andi have update
index in background set.
It seems to have worked for a while, then stopped. The application event log

I'm trying to improve a crawl's performance.  Online books refers to
changing the default batch size from 1600 to a number associated with the
number of processors on my server.
For the life of me, I have no idea how to go about changing the batch size

This is an old one, but I haven't been able to fix this just yet. We
have a Win2k SP4 server which runs SQL server 2000 with the latest
service packs and updates and everything. The server is a webserver
that's being hosted at a hosting provider. There's absolutely nothing

I have a fulltext index on the "INSUMOS" table with the following options:
1) Default language is spanish
2) The NOISE.ESN is empty (i.e. index everything)
3) The catalog is updated

What would be an efficient way to check for the integrity of a FT
catalog or index in SQL 2000?  Beside monitoring the event logs,  I'm
planning to write a script to parse out a string of text from a text
column of a random row from a table has FT indexes, then go back and do

Hi,
       I am running sql 2000 sp 3a on a ms cluster with w2k sp3.
       this below error occurs suddenly from aug 8th, which in turns the
sql full-text will failed.

configuration
hardware: cpu 4*1.5G  RAM 2G
software: windows 2000 server,sql server 2000
data: records >40 million ,spaceused > 14G

I just want to know, is there any procedure to remove SQL Server full text
from a cluster enviroment? My provider ask me to do that but i want an
official document from MS about how to do it or if it is not possible.
Thanks for the help.

I am looking for "ABOUT" and i get this error
Server: Msg 7619, Level 16, State 1, Line 1
Execution of a full-text operation failed. A clause of the query
contained only ignored words.

MSSQL 2000 sp3a, on Windows 2003.
I will use examples from BOL. I am searching with a CONTAINS like this:
WHERE CONTAINS(ProductName, ' "sasquatch ale" OR "steeleye stout" ')
and am receiving results like 'sasquatch's ale' and 'steeleye's stout'.

Hi all, I have 2 questions
1.- How can i search for "%" using like
select * from table where sfield like '%%%'
is not working!