Cannot Delete Fulltext catalog from DB

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  July 19, 2006 at 1:13 pm

  #62083

  Hi all

  I check Full-Text catalogs under mydb database and see that mycatalog is empty

  no tables nothing just sitting there. i want to delete it but can't it gives me the error message:

  Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_catalog, Line 79

  Execution of a full-text operation failed. The specified object cannot be found.

  Specify the name of an existing object.

  When i query mydb with sp_help_fulltext_catalogs

  I get 2 rows

  FTCATIDNAME

  5mycatalog

  6myothercatalog 

  I want to drop mycatalog with EXEC sp_fulltext_catalog 'mycatalog', 'drop'

  I get the same error message as above.

  What's going on?  

  How can i get rid of this catalog?

  Thanks
  

  Alex S

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  July 19, 2006 at 2:11 pm

  #650239

  Check Path field of sp_help_fulltext_catalogs for mycatalog. Make sure this path and  the catalog exist on your server. The default location is:                                                      

  Drive:\Program Files\Microsoft SQL Server\MSSQL\FTDATA

  Regards,Yelena Varsha

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  July 20, 2006 at 9:22 am

  #650428

  Yelena it does exist in C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA.

  Do i just delete the folder???

  Alex S

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  July 20, 2006 at 3:47 pm

  #650544

  Alex,

  I would not delete the folder. Because you have SQL Server pointing to this folder.

  I read the message again. It says "The specified object cannot be found". It is just an assumption that object is catalog. It may be something else. Moreover, it says that the problem is on the line 79 in the procedure. This line says "DBCC CALLFULLTEXT (2,@ftcat) " with the comment "--FTDropCatalog(@ftcat)

  You can look up at this site for "Undocumented DBCC commands" if they have a description of this DBCC and what it wants. Also check if FTDropCatalog function exisist and see what it does.

  This line is 79, it is past much of the verifications, go the text of sp_fulltext_catalog and see for yourself. The convenient way to see line numbers is just to paste sp text to the Query Analyzer window, it shows lines at the bottom.

  Also, check if the catalog name contain spaces, dashes, keywords etc. Maybe you need to enclose it in the brackets or quotes?

  Regards,Yelena Varsha