SQL Server full text catalog

Question

Is below one is a database specific or at instance level:

sp_fulltext_service 'clean_up'
If I use above command, will it clean all the full text catalogs on all of the databases. Or it will clean   only one database full text catalog where I execute this command.
Please let me know your thoughts if anyone uses this command earlier.
- Illiyaz Syed

Answer 1

cleans on all of the database/services and returns a null value

Searches for and removes the full-text catalog resources in the file system that do not have corresponding entries in sysfulltextcatalogs.

check this blog

http://msdn.microsoft.com/en-us/library/aa933403%28v=sql.80%29.aspx

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

Hi Syed,

As per BOL,why the cleanup for fulltext means is as mentioned below (also note that it is in SQL server 2000 how ever still it is available 2005 + onwards with backward compatibility only)-

"There may be times when the metadata for a full-text catalog is changed (for example, when the full-text catalog is dropped or the database is dropped) while the Microsoft Search Service (MSSearch) is not running. The drop action changes the metadata related to the full-text catalogs but is unable to complete execution because the Microsoft Search Service is not running. This leads to inconsistency between the full-text metadata in SQL Server and the associated physical full-text catalog in the file system. This inconsistency can be corrected by using the clean_up action of sp_fulltext_service. Microsoft Search Service must be running".

---

Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and un-mark them if they provide no help.