I have recently installed Full Text search component using the SQL 2000
Server CD, but still the Full Text Indexing option is disabled under Tools in
SQL 2000 Enterprise manager. Also I don't get Full Text Search option under
Support Services in Enterprise Manager. Although I am ...

My understanding from full-text search (with SQL 2000) is that you can only
search a table and not a view; i.e. you cannot create a full-text index for
a view.
1) Is there a way to full-text search a view?

In Yukon, if I do a fulltext search and also put let's say "userid = 5" in
the where clause, for example, [Where contains("description","yukon") and
userid = 5]
Does Yukon search for all the "yukon" among all the datarows first or search

I'd like to implement incremental population for a given table.
I don't understand if I need to use both "sp_fulltext_catalog" and "sp_fulltext_table" to accomplish this task. BOL is a bit nebulous in their explanation.
"sp_fulltext_catalog" has an @action value of ...

HI!,
Fulltext search is not working, i have two databases, fulltext search
functionality was working fine on both of them till now. but suddenly
fulltext search on one of the databases started giving out errors.

Database size=150 GB
FT indexed Table = 120 millions of records.
On the start of project database was small and FT catalog builds
successfully.

I have a large db and some large FT catalogs.
When I try to delete ftcatalog I see msg: "Server can not obtain LOCKS ...."
Why this message?
Its my test-server and no any users.

I am getting this error when my query contains a word like "of":
"A clause of the query contained only ignored words."
The SQL statement uses the CONTAINS clause. This used to work fine on SQL
Server 2000, but I recently switched to SQL Server 2003 and can't get it to

I have a table which data is organized as follows,
Style                        Color  Size_Qty
MEW6SQ215        101     XS,12; S,12; M,10;
MZ10E727L           360     29,2;30,4;31,6;32,4;33,2;

i'm a beginner in sql server 2000 and i have a question.
i want to store word, excel, pdf etc documents in order to search them
for specific content. i don't want to get as result lines of the
documents but the names of them.What data type i must use? can i search

it is really funny how ft search works:
it seems to depend highly on what could be indexed, but it still doesn't  
follow a determined order.
consider the following queries:

Can I create an Insert Into Query without sql server registration log?
Thx.

The situation is the following: I have table names "authors" with the
columnes

Is it possible to create a custom word breaker for SQLServer fulltext.... I
use french word breaker, but for some specific tables, it's not exactly what
I want...
Seems such a dream will be feasible in SQL 2K5.

If we restore a backup copy of a production db having FT catalogs onto a
laptop running SQL Server Developer version, the restored db will contain
references to FT catalogs whose underlying system files are not yet present
on the laptop (because backup doesn't grab the FT system ...