Re: can't delete a full text catalog

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 11/06/04

  • Next message: Hilary Cotter: "Re: Performance problems -- need guidance on scaling" 
    Date: Fri, 5 Nov 2004 20:53:36 -0500

    Can you try to right click on your table in EM, and select Full Text Index
    Table, and then select edit. Click through the dialogs until you get the new
    catalog creation dialog. Create a new catalog.

    This will clear some of this class of errors. If this won't work you will
    probably have to use some of the full text procedures and possibly manually
    remove some rows from the system tables. Post back here and I'll try to
    help you further with this. 

    -- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jorge Ribeiro" <JorgeRibeiro@discussions.microsoft.com> wrote in message
news:F60177EB-6333-4755-A035-202EC62FB27F@microsoft.com...
> Hello
>
> I've defined a full text catalog that indexes several columns from two
tables.
> Now I want to erase it and it simply don't let me... using the console it
> reports that my catalog has been lost and to use sp_fulltext_catalog to
> repopulate or rebuild it...
> I tryied so and the error was the same...
>
> i need to erase that useless catalog because it don't work anymore and i
> need to do another one with the same name...
> how can i get it done?!?!
>
> best regards
>
> Jorge Ribeiro
  • Next message: Hilary Cotter: "Re: Performance problems -- need guidance on scaling"

    Relevant Pages

    • Re: How to qustion from PS Elements user
      ... strip/delete/paint the background out of photos I'm preparing for a catalog? ... is it best to erase the background or paint as much as possible ... If your goal is to prepare a job for printing on a professional printing ...
      (alt.graphics.photoshop)
    • Some expert comment please
      ... i looks in a catalog för files ending on .tmp ... and erase them, could make it on 1 line ...
      (comp.lang.lisp)
    • cant delete a full text catalog
      ... I've defined a full text catalog that indexes several columns from two tables. ... Now I want to erase it and it simply don't let me... ... best regards ... Jorge Ribeiro ...
      (microsoft.public.sqlserver.fulltext)
    • Re: cant delete a full text catalog
      ... Hilary Cotter ... "Jorge Ribeiro" wrote in message ... > I've done what you sujested (create a new catalog) and the result was the ... >>> i need to erase that useless catalog because it don't work anymore and ...
      (microsoft.public.sqlserver.fulltext)
    • Re: cant delete a full text catalog
      ... I've done what you sujested (create a new catalog) and the result was the ... the catalog has been lost and so on... ... >> i need to erase that useless catalog because it don't work anymore and i ... >> Jorge Ribeiro ...
      (microsoft.public.sqlserver.fulltext)