Misterious disabling of table FTS

Hi all,

Today two tables in the same database ( which are the only ones with FTS in
that database) had FTS disabled. I know for sure that yesterday both of
them were enabled and working and nothing is showing in the logs about any
change to the status ( apart from the normal automatic PAUSE and RESUME of
indexing for the daily backup. ).
When I manually re-enabled each table the same message was created in the
logs:
"Changing the status to MERGE for the full-text catalog ".

Although everything is working now I am trying to track what could of caused
this.

Apart for purposely setting the table FTS disabled manually, what other
event could have caused the table's FTS become disabled?

Other databases in the same server had FTS on tables that weren't affected.

Thanks for the help.

Francisco






.

Relevant Pages

  • Re: need to implement full text search
    ... These are some of the advantages of SQLite's full text search (FTS) over your ... You can OR terms (apples OR pears), exclude terms, perform ... The free DISQLite3 Personal edition contains the SQLite3 database engine as well ... object_id from mytable where keyword like '%akeyword%' ...
    (borland.public.delphi.thirdpartytools.general)
  • Combining FTS and Index Server
    ... indexing, so I'm not sure exactly what I'm looking for. ... I'm familiar w/ FTS, as I have used this for a message board on another ... both files and database content at the same time. ... and PDF files for storing in the database? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Misterious disabling of table FTS
    ... Just to add this was on SQL 2005 sp1 ... Today two tables in the same database (which are the only ones with FTS ... of them were enabled and working and nothing is showing in the logs about ...
    (microsoft.public.sqlserver.fulltext)
  • Full Text Search question
    ... The database that I am going to hit up against ... What is the best method to use FTS against so many tables? ... Could I build a massive query that dumps the results into a single ... I know this problem isnt unique to our company but just wondering how ...
    (comp.databases.sybase)
  • FTS capabilities + questions
    ... The database that I am going to hit up against ... What is the best method to use FTS against so many tables? ... Could I build a massive query that dumps the results into a single ... I know this problem isnt unique to our company but just wondering how ...
    (microsoft.public.sqlserver.fulltext)