Ok, say I want to pull back all '"picture ~ frame"' and '"pictures ~
frames"' so I do the following; FormsOf(Inflectional, "picture ~ frame")
this results in syntax error. I thought inflectional would automatically do
it if I put " around the near words. The first ones I listed ...

Hello, It is possible to search text in my blog use a query sentence instead
of several key words? Which I mean, if I want to get to know "How rich is
Bill Gates?", I can simply enter this sentence instead of enter
"Bill+Gates+rich+how" in my search textbox. If it is applicable, ...

I have a Windows Server 2003 & SQL Server 2000 (SP4) EE cluster setup
using FTS on one table. It seems that when one node was failed over it
started throwing the following errors shortly after the crawl job
starts:

I have a pile of documents I want to index.  My plan is add their text
content to a text field in a VS2005 express database, then use a full
text index to index the document contents.
In my particular situation I do not really need to store the actual

I want to search in fulltextindexes for multiple searchterms in multiple
columns. The difficulty is:
I don't want only the records with columns that contains both searchterms.
I also want the records of which one column contains one of the searchterm

Reading the MS article "10 Ways to Optimize SQL Server Full-Text Indexing"
http://msdn2.microsoft.com/en-us/library/aa175787(sql.80).aspx
It says regarding a full population:
   "MSSearch will issue sp_fulltext_getdata once for every row in your

Which is better to index. A view that pulls in all the fields I need and
indexing the view or indexing the tables I need and then merge the indexes.
I am looking for performance here. I have about 6 different tables that I am
joining in the view and only gettting the fields I ...

We have suddenly started having a problem with a webserver locking up as
a process called msftesql.exe uses 100% CPU on all processors. This
causes the server to be so unresponsive that it can only be shut down by
holding down the power button.

I am trying to use freetext to return "best match" results from a database
with movie titles, and it gives me a few different results than what I would
like it to.
I should properly mention that I have just looked at freetext in a few days,

    Is there any way to work around the behavior of searching for a term
which has hyphens in it? I've seen the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q200043 which
only suggests doing a non-FTS search. Is there no way to transform the

The gather logs are huge, full of mostly "success" messages, and are
massively slowing down our FT population time. Can I safely delete
them?

I am undertaking a project which requires the ability to perform
phonetic searching across business and personal names and addresses.
This data is relatively uncleansed to date.  The amount of work to
cleanse the data is tremendous based upon existing data analysis.  My

Does anyone know whether we can get Unicode search working on Sharepoint
services v2.0.
I know WSS 2.0 uses SQL Server's full-text-search.
Andy Bolton

i can again/still/no longer manage full-text indexes on SQL Server.
i'm logged on locally to my server, as an administrator. EM is set to poll
the server.
Has anyone written a gui to manage SQL Server free-text indexing?

Hello, I have a SQL Server 2000 sp4 server.  Trying to install Full-Text
Search.  I can see the Microsoft Search service and it shows as started.  But
the Full-Text Search option in SEM is 'grayed out'.  The FTS system procs
also report that FTS is not available.  SQL Server has ...