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 changes2. 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
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
]]>