Re: When does Full Catalog Break.
From: John Kane (jt-kane_at_comcast.net)
Date: 07/02/04
- Next message: PuOn: "REGEXP in sql"
- Previous message: John Kane: "Re: When does Full Catalog Break."
- In reply to: John Kane: "Re: When does Full Catalog Break."
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Jul 2004 21:17:26 -0700
Some additional link, good content, but a bit dated...
Extensions to SQL Server to Support Full-Text Search
http://www.microsoft.com/technet/prodtechnol/sql/70/maintain/sql7fts.mspx
Textual Searches on Database Data Using Microsoft SQL Server 7.0
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/textsearch.asp
Search the SQL Server 2000 Books Online (BOL) for "full text" (with the
double quotes) for more current and SQL 2000 up-to-date info.
John
"John Kane" <jt-kane@comcast.net> wrote in message
news:#f3HEU#XEHA.3012@tk2msftngp13.phx.gbl...
> 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: PuOn: "REGEXP in sql"
- Previous message: John Kane: "Re: When does Full Catalog Break."
- In reply to: John Kane: "Re: When does Full Catalog Break."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
