I'm trying to install full-text search service on SQL server using command
ftsetup.exe, but I always get error "FulltextSetup returned error code:
0x80000023".
I've upgraded MSDE with SQL Server 2000 standard . Upgrade process did not

Does anyone know if this affects when the FTS os on the second node to
incremental population?
Thxs.

I have a job the runs nightly that does a brute force "exec
sp_fulltext_catalog @FtcName, 'start incremental'" on all customer
databases and all FTC.
I noticed that for a few days in a row that in specific databases there

Full text seach is working on my Development machine.
I created a similar full text search catelog on my test machine.But I am not
getting any results back.I chekced the event log..Every time it runs there
are four warnings which says

   I am confused by the different method of population, of both Full Text
index and Full Text Catalog.
   Currently, we are running a application (3rd party) on SQL 2000, and we
have set the Full Text indexing to be "Change Tracking" and "background

Hello , all
I try to run SELECT with contains function
select * from a
where (a.t , '"only*"')

Maybe someone knows if this is possible...
I managed to get the Thesaurus working for full text searching, which
required me to restart the msftesql service.
So my question, is there a programable way to restart the service within the

I have an installation that move their database to a cluster server.
SQL2000 has SP3 applied.
We created a new FTS against a single table, single row.
The table has 500,000 rows of data.

Can I search(one query) against columns from two tables.Please share a basic
example.How does the ranking work in this case.

Hi,
I have CRM database that contains full-text catalogs. Someone delete rows by
mistake. I need restore this database to same server from last night backup,
after database restore, do I need manually active full-text indexes or it

like google Advanced Search in SQL full-text search?
I use :
CONTAINSTABLE(table_full_text_search,*,'"for" and "dog" ') to search the
(all of the words).but the "for" is noise word,I cannot search...

Hello.  This is my first experience with full-text indexing and immediately
I'm having problems.
I set up full-text indexing on the "referenceCompany" column of table "Reference"
and ran the population routine.  All queries against this table are failing:

I have full text in a MS SQL database table.
I also have a string "Search" which contains all the keywords passed in
the URL to the page.aspx. I want to use the keywords.
What I have now is this:

I have a 10 million row table with two columns(name, address) full text
indexed. I want to search the table for
the first 200 occurances of "Bob jones" in the name field. I have ran
another query to find out that there are actully 15,291 rows with "Bob Jones"

I have a fulltext indexed table (aTest) which look like this
(strCaption and strText are both fulltext indexed columns):
lngStoryId  strCaption               strText
----------- ------------------------ ------------------------------