Full Text Catalog | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Full Text Catalog

Hi, Can someone give me a detailled explanation of what is the difference between the below two in SQL Server 2005 1. Setting the Full Text index/ catalog to auto track the changes
2. Right clicking on a table that is full text indexed and go to Full text index –> and "start incremental population" Also when you run the select statement
select * from sys.fulltext_indexes I would want to know what is Crawl_type (or ) crawl_desc and when it changes from F to I or from I to F. and what is the impact? Thanks