How can I know when SQL Full Text Index Population is finished?

by

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 THEN 'Incremental Population In Progress'
        WHEN 7 THEN 'Building Index'
        WHEN 8 THEN 'Disk Full.  Paused'
        WHEN 9 THEN 'Change Tracking' END) AS PopulateStatus

Results:

LastPopulated           PopulateStatus
----------------------- ----------------------------------
2012-05-08 14:51:37.000 Idle

(1 row(s) affected)

More Related Contents:

  1. Where clause not working in sql server
  2. Alias name is same as column name [closed]
  3. Compare the values of column in SQL Server
  4. T-SQL stored procedure that accepts multiple Id values
  5. LocalDB deployment on client PC
  6. Understanding PIVOT function in T-SQL
  7. How do I escape a percentage sign in T-SQL?
  8. Using RegEx in SQL Server
  9. What is the best way to auto-generate INSERT statements for a SQL Server table?
  10. Get list of databases from SQL Server
  11. CAST and IsNumeric
  12. SqlServer: Login failed for user
  13. SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
  14. SQL Update with row_number()
  15. Calendar table for Data Warehouse
  16. SQL Server default character encoding
  17. Return all possible combinations of values on columns in SQL
  18. SQL Server error on update command – “A severe error occurred on the current command”
  19. Recursive sum in tree structure
  20. SQL Server SP – Pass parameter for “IN” array list?
  21. Why the SQL Server ignore the empty space at the end automatically?
  22. Add default value of datetime field in SQL Server to a timestamp
  23. SSIS reading LF as terminator when its set as CRLF
  24. What are some ways of accessing Microsoft SQL Server from Linux?
  25. LPAD in SQL Server 2008
  26. How do I remove non-breaking spaces from a column in SQL server?
  27. Why is casting from float to varchar being rounded in SQL Server?
  28. Conditional JOIN Statement SQL Server
  29. How do you deal with blank spaces in column names in SQL Server?
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment