How to rebuild full-text index?

Question

Got a requirement to rebuild mssql full-text index.
Problem is - i need to know exactly when job is done. Therefore - just calling:

ALTER FULLTEXT CATALOG fooCatalog
REBUILD WITH ACCENT_SENSITIVITY = OFF

doesn't work or I'm doing something slightly wrong. :/

Any ideas?

Answer 1

You can determine the status of the fulltext indexing by querying the indexing properties like this:

SELECT FULLTEXTCATALOGPROPERTY('IndexingCatalog', 'PopulateStatus') AS Status

Table Full-Text Populate Status

Displays the population status of the full-text indexed table.

The possible values are as follows:

0 = Idle.

1 = Full population is in progress.

2 = Incremental population is in progress.

3 = Propagation of tracked changes is in progress.

4 = Background update index is in progress, such as automatic change

tracking.

5 = Full-text indexing is throttled or pause