There is a stored procedure sp_fulltext_service which takes the property to
be changed or reset and the value of the property as the parameters.
sp_fulltext_service [ [@action=] 'action' [ , [ @value= ] value ] ]
If value is NULL, sp_fulltext_service returns the current settings.

i, like hundreds of other people, am unable to use the Full Text indexing
feature because of the bug in SQL Server Enterprise Manager that disables
the ability to configure it.
See the Microsoft Knowledge Base article, but realize that it doesn't apply.

We're using SQL Server 2005 service pack 1.  It was my understanding that
FreeTextTable automatically includes inflectional forms.  We're not able to
get any inflectional forms of words during the search (even if we use
Contains with the special syntax).  Are we missing something ...

Still working on this query:
select *
from products
inner join freetexttable(products,*,@searchstr) ft1

We are having a performance problem with our FTS (running on Sql
Server 2000 Std vs a MS Commerce 2002 FP1 website.  All running on
Server 2003 OS.  SQL and webserver are on different machines).  Once
the re-population is complete, the FTS runs fine.

Hi All: Last month, I was looking for way to query 3 FT tables
simultaneously.
I found that a UNION with 3 separate queries worked, but someone pointed out
that duplicates would occur (and they did).

Running
SELECT productid,productname from productsFullText
where
freetext (*, 'x2000')

Is there a way to get the FTS system to return you the count of matches
only, without passing back all the key ids.
Basically if a user doesn't find what they are looking for with their
initial multi term search, i.e '10k resistor tomatoes'.

I am running the below query and getting back results that have the word
"mode" in it. Isn't the keyword CONTAINS supposed to treat my search
expression as one word? Can someone show me what is wrong with this query so
that it returns only records that have the exact search ...

I have been writing a search engine that uses FTI, and have read that
you cannot use leading wildcards in your search clause (i.e. "*ome"
would not return home, but "hom*" would return home).
Just wondering if there is a solution to this problem while still

 I would like to know the major difference between Incremenatal Population
and Track Changing Population.  The only difference that I've found is the
Incremental needs to have a timestamp column in the table.  How do I decide
if I should use Incremental or Track Changing?  are ...

I'm not sure what I did generates the correct result...I think I got the
information here but I don't remember as it was a few years ago.
I edited the noise-ENU file and removed the letter C from the last line.
Then I did rebuild on the indexes.

I just upgraded from msde to sql express and need a way to run my existing
jobs. I tried sqlschedular but dont seem to get it to work. How can I access
or run my existing jobs.
Help is appreciated

   I'm new to this group, i've a problem with the full text search
with sql server 2000,
I've been searching for a word (say "the") in the a full text indexed
table for each column and i get the error as :

Does the new text search method in SQL Server provide a “best match” text
search? Does it work similar to a Google search, for example, where the most
words that match gets the highest relevancy score, then these should appear
first. I wondered if the new text search provided a ...