0

I am looking for a way to call the following only if the fulltext index status is paused but I can't seem to find the query I need to get the population status of a specific table

ALTER FULLTEXT INDEX ON dbo.my_table RESUME POPULATION

I have several indexes in the one fulltext catalog so I cannot rely on sys.fulltext_catalogs. I have checked sys.fulltext_indexes and the two indexes - one running and one paused - appear identical.

Seph
  • 8,472
  • 10
  • 63
  • 94

1 Answers1

0

Use the catalogue property function...

https://technet.microsoft.com/en-us/library/ms190370.aspx

For example:

SELECT
    FULLTEXTCATALOGPROPERTY(cat.name,'PopulateStatus') AS [PopulateStatus]
FROM 
    sys.fulltext_catalogs AS cat

A status of '2' is paused.

Paul Andrew
  • 3,233
  • 2
  • 17
  • 37
  • > "I have several indexes in the one fulltext catalog so I cannot rely on `sys.fulltext_catalogs`" – Seph Jun 22 '16 at 13:42