When does Full Catalog Break.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JJF184 - 01 Jul 2004 18:24 GMT

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.

Reply to this Message

John Kane - 02 Jul 2004 04:31 GMT

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

> 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.

Reply to this Message

John Kane - 02 Jul 2004 05:17 GMT

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/tex
tsearch.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

> JJF184,
> It's always helpful for troubleshooting SQL Full-text Search (FTS) issue to
[quoted text clipped - 35 lines]
> > If you could point to any good reference about full text cataloging I
> would apreciate it.

Reply to this Message