puresourcecode.com
How can I know when SQL Full Text Index Population is finished?
When you execute some queries on your SQL Server, are you sure the catalog is being imported? With this simple script you can know which is the Index status. DECLARE @CatalogName VARCHAR(MAX) SET @CatalogName = 'TEST_FullIndex' SELECT FULLTEXTCATALOGPROPERTY(@CatalogName,'ItemCount') as NumberOfItems, FULLTEXTCATALOGPROPERTY(@CatalogName,'ImportStatus') as ImportStatus, DATEADD(ss, FULLTEXTCATALOGPROPERTY(@CatalogName, 'PopulateCompletionAge'), '1/1/1990') AS LastPopulated, (SELECT CASE FULLTEXTCATALOGPROPERTY(@CatalogName,'PopulateStatus') WHEN 0 THEN...
Enrico