Re: When does Full Catalog Break.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Kane (jt-kane_at_comcast.net)
Date: 07/02/04

  • Next message: John Kane: "Re: When does Full Catalog Break." 
    Date: Thu, 1 Jul 2004 20:31:09 -0700

    JJF184,
    It's always helpful for troubleshooting SQL Full-text Search (FTS) issue to
    have the SQL Server and OS platform version. Could you post the full output
    of -- SELECT @@version

    There should be no problems with deleting all rows (records) from a
    FT-enabled table, as with dropping or deleting the actual table. Dropping a
    table is a different operation and deletes rows that are in various system
    tables, that if the table is FT-enabled, would require you to drop the FT
    Catalog first.

    Attaching is not the correct word, as much as "associate" the FT Catalog
    with the table is, because you can "attach" a database, but you cannot
    "attach" or detach a table. When your FT-enable a table, various system
    tables (sysobjects, sysindexes and syscolumns) are updated with the fact
    that the table is now FT-enabled. When you deactivate or drop the FT Catalog
    those links are then reversed.

    A good KB article that describes the procedures for moving a FT catalog -
    240867 (Q240867) "INF: How to Move, Copy, and Backup Full-Text Catalog
    Folders and Files" at
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867 should be a
    good place to start, other than the BOL, of course!

    Regards,
    John

    "JJF184" <JJF184@discussions.microsoft.com> wrote in message
    news:0548E4F1-3A9D-4D4E-A7F3-6CEA788CEDA0@microsoft.com...
    > Will the full text catalog break if I delete all the records from a table.
    I dropped the table and the Full text catalog broke.
    >
    > My assumption is that it is attached to the table and when the table is
    dropped the catalog is also lost. Is this correct.
    >
    > I need to change all the data in the table, for an upgrade and don't won't
    to break the catalog. It is OK if the catalog doesn't match until
    repopulated.
    >
    > If you could point to any good reference about full text cataloging I
    would apreciate it.

  • Next message: John Kane: "Re: When does Full Catalog Break."

    Relevant Pages

    • Re: data from access to word
      ... Use a catalog type ... mailmerge main document to which you attach your table in Access as the data ... services on a paid consulting basis. ...
      (microsoft.public.word.docmanagement)
    • Damaged Catalog Alert
      ... We had a catalog break a little yesterday. ... I sent the dump to IBM and they came back with: ... A catalog in ECS took a new extent but later errors were ...
      (bit.listserv.ibm-main)
    • RE: Damaged Catalog Alert
      ... We had a catalog break a little yesterday. ... DUMP TITLE=CAS DYNAMIC DUMP-IGG0CLEG RC26 RSN8 ... A catalog in ECS took a new extent but later errors were ...
      (bit.listserv.ibm-main)
    • Re: Attaching Shortcut Instead of Original File
      ... catalog merge document, that is what should be attached. ... "Murat Gordeslioglu" wrote in ... > shortcut instead of original file. ... What should I do attach a document ...
      (microsoft.public.word.mailmerge.fields)
    • When does Full Catalog Break.
      ... Will the full text catalog break if I delete all the records from a table. ... I dropped the table and the Full text catalog broke. ... If you could point to any good reference about full text cataloging I would apreciate it. ...
      (microsoft.public.sqlserver.fulltext)