March 22, 2005 at 1:29 pm
I’m trying to delete a Full Text Catalog that:
1. Is no longer needed.
2. Was created with an unknown account.
I receive the following:
---------------------------
Microsoft SQL-DMO
---------------------------
Error 21776: [SQL-DMO]The name 'FT_Problems_Table' was not found in the FullTextCatalogs collection. If the name is a qualified name, use [] to separate various parts of the name, and try again.
Any ideas on how to delete this?
March 23, 2005 at 1:06 am
Yes, I do. However, before you can delete the FT Catalog, I need to know more about your enviroment. Could you run the following SQL code and post the results in your reply?
use <your_database_name_here>
go
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
go
select * from sysfulltextcatalogs
go
It may be as simple as executing the following sql code: EXEC sp_fulltext_service 'clean_up'
or it may be more complex, with manually deleting rows from sysfulltextcatalogs and registry keys.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
John T. Kane
March 23, 2005 at 1:08 am
Hi,
you have to build this catalog and than delete.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply