I have a table with several FT-enabled varchar columns, in SQL Server
2000.
If I ask for SELECT * FROM tbl WHERE CONTAINS(*, SearchStringA) I get
several rows.  (as expected)

We use fulltext search on a MS SQL 2000 SP2 server.
When a user that have administrator permissions on the server makes a search
everything goes well, but
when a non administrator user searches he gets a timout.

I would like to perform a search for a string (for example "0021-899-1234")
that could reside in any table
within a given database.  (I performed a massive change and I would like to
spot check to ensure that I got all

I receive a 7619 error message when I run a full text query that
contains certain Turkish character strings on an instance of SQL Server
2000 that is running on a Windows 2000-based computer. How can I solve
this problem?

Is there a way to programmatically determine (perhaps by interrogating the
system catalogs) if a column supports full-text searching.
In my application I want to use "CONTAINS" where support is available but
deprecate to "LIKE" where it is not.

I have a large table (around 15m rows) I'm trying to Full-Text index using
the Japanese wordbreaker.
When I do a full process, after processing 3-4 million rows, I see a couple
of "Error Fetching URL (80070006 - Invalid handle)" records in the Gather

I have just installed Sql server 2000 developer edition (mixed mode
auth) and have installed and started the Microsoft Search Service
(which runs under the local system account) However the Full-Text
indexing option is grayed out? I have another development machine which

I want to search for a substring that is contained in one of the indexed
words.
For example, the catalog contains "00001498ABC"
I want to search for the substring "1489" since I don't know what the

Been reading thru all the posts and KB's on dealing with searching
across multiple columns.  Most examples indicate you know what you're
looking for in each column.
Here's my big problem:

Ok, why are my indices all paused?
Ran out of diskspace the other day.  Stopped the Service, moved the indices
to another drive (had a little problem with 1-2 of them which I believe I've
fixed.)

I have a merge replication process that is having some major performance issues.  The replication process seems to run just fine for about a half hour (200k records), and then it hits a brick wall.  I continually get the message:
"The process is running and is waiting for a ...

I build FT catalog for my database which has 10GB size. Catalog wa
built and populated ok
But our customer has the same database (120 GB) and I run populatio
and two weeks  I see 'Paused', 'Recovering' and so on. FT Catalo

i am using a very long query in a containstable predicate with an isabout
search method.
somthing like this :CONTAINSTABLE( dbo.TBL_FTS_DATA,FreeTextDump,
'ISABOUT(.....

On the SQLServer SP3 my stored procedure worked fine.
I have install SP4 and rebuild FT catalogs. I dont delete and create new,
but only rebuild.
Now for example, I entered word 'putin' and 'rasputin'  into table with ft

I´m have problems with FTS used by CS and SPS.
I saw a article 308797 that requires a support pack. How can I obtain this
support pack until I test a SP4 for verify if this problem fix in Service
Pack.