How can I know when SQL Full Text Index Population is finished?
I would like to offer an easier-to-read version of @Daniel Renshaw’s answer: DECLARE @CatalogName VARCHAR(MAX) SET @CatalogName=”FTS_Demo_Catalog” SELECT DATEADD(ss, FULLTEXTCATALOGPROPERTY(@CatalogName,’PopulateCompletionAge’), ‘1/1/1990′) AS LastPopulated ,(SELECT CASE FULLTEXTCATALOGPROPERTY(@CatalogName,’PopulateStatus’) WHEN 0 THEN ‘Idle’ WHEN 1 THEN ‘Full Population In Progress’ WHEN 2 THEN ‘Paused’ WHEN 3 THEN ‘Throttled’ WHEN 4 THEN ‘Recovering’ WHEN 5 THEN ‘Shutdown’ WHEN 6 … Read more