can't delete a full text catalog

[Jorge Ribeiro]

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

[Hilary Cotter]

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" <JorgeR...@discussions.microsoft.com> wrote in message
news:F60177EB-6333-4755...@microsoft.com...

[Jorge Ribeiro]

Hi

I've done what you sujested (create a new catalog) and the result was the
same... the catalog has been lost and so on...
it didn't create a new catalog and the old one still persists

what can I do now?!?!

thanx

Jorge Ribeiro

[Hilary Cotter]

drop the catalog using sp_fulltext_catalog 'catalogname', 'drop'

After you have completed doing this, delete the rows from
sysfulltextcatalogs

Then try to build your catalogs again.

--
Hilary Cotter
Looking for a SQL Server replication book?

Now available for purchase at:
http://www.nwsu.com/0974973602.html

"Jorge Ribeiro" <JorgeR...@discussions.microsoft.com> wrote in message

news:C159A27C-6C4F-4743...@microsoft.com...

[Jorge Ribeiro]

i've already done that
i've got an error message

Cannot drop full-text catalog 'cat_intranet_teste_paginas' because it
contains a full-text index.

can i still delete the catalog row from sysfulltextcatalogs?!
will it work?!?!

[Hilary Cotter]

back up your database. Then delete the rows.

Then try to create another catalog, and go back and edit the tables to move
them to the new catalog.

"Jorge Ribeiro" <JorgeR...@discussions.microsoft.com> wrote in message

news:096B13D9-C590-4B33...@microsoft.com...