I am tasked with designing a procedure that a client could use to move to a
different database server wuthout losing their data or full-text index. I am
using the KB article Q240867 section labeled "To copy full-text catalogs
between instances of SQL Server to the same local drive ...

I changed the MSSSQL accoutn using EM not Control Panel...
Does anyone else know what i can do?

Can anyone tell me why this doesnt work:
1- full text service is running under local system account
2- sql server is running under a domain account
3- local admin consists of both (domain admins and system)

I don't want any noise words at all for my current application, so have
cleared out the noise.enu file so it is 0 bytes and re-built the catalog
I am pretty sure it is working ok because I can search on 'the' and 'of' etc
which I couldn't do before. however, if I try to search on a ...

I'm getting very frustrated with the usual "A clause of the query
contained only ignored words" problem when using fulltext searches.
Is there any way at all I can prevent this error from happening? Is it
safe to change my noise words file to be empty and force a repop? I

I have asked (and had a reply - thanks!) this question before, but i'm in a
hurry and cant seem to find the solution even by googling myself.
I have a database which had a FT catalog on E: on one machine and i've moved
the database to a machine with only a C:

I have a large full text index (30 millions records) that is
populating on a live server (they are just doing without the full text
search stuff for now) and the index goes into shutdown mode.  What is
that????  Last time it did this i stopped and started the mssearch

I am trying to update an ntext field between two servers.
The sintax I am using is the following:
DECLARE @ploc binary(16)
DECLARE @prem binary(16)

I have a project that uses a linked server in SQL Server 2000 to query a
local Index Server. This works fine.
I've been experimenting with moving the catalog to a remote Index Server and
querying it via Index Server running on the SQL Server machine (using the

using SQL server 2000, I have a ft indexed column that contains the name
O'Donnell (for the sake of argument).
using CONTAINSTABLE, I would like to match this against any of the following
search criteria:

In the below FREETEXTTABLE query, I have the SELECT fields indexed in the FT
catalog. I should be getting results and I'm not. The problem, as I see it,
is that I need to be searching all 3 tables when actually I'm only searching
1 table in this expression: FREETEXTTABLE(ItemStock, ...

Using the following query I get my desired results. However, in the
resulting recordset, how can I show for example 10 words before and 10 words
after the keyword or phrase that was searched upon? If I get 20 resulting
records I think it would be easier for the user to decide which ...

We're having some difficulty getting adequate search results.  We're trying to search across 3 columns, "author", "title", and "subtitle" (no other columns are part of FT index).  The problem relates to searching for an author/title phrase at the same time.  Say the user types ...

I'm looking for in-depth information on the search functionality of
SharePoint 2003. As it is using the SQL full-text search, I post my question
to this newsgroup.
The main goal is to figure out how I can add the functionality of rating

We are still struggling to get stable operation with full text indexing.
After a variety of problems that I have posted before, I am trying a smaller
table with about 3 million rows, and I'm using incremental builds rather
than change tracking.