Full Text in SQL Server 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Full Text in SQL Server 2005

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

Refer under the books online for SQL 2005 for enhancements in this case. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.