How to define if rebuilding of the full text index has finished?

sql-server full-text-indexing
Arnis Lapsa picture Arnis Lapsa · Jul 7, 2009 · Viewed 20.6k times · Source

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

Magnus Johansson picture Magnus Johansson · Jul 7, 2009

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

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

Populate Status:
0 = Idle
1 = Full population in progress
2 = Paused
3 = Throttled
4 = Recovering
5 = Shutdown
6 = Incremental population in progress
7 = Building index
8 = Disk is full. Paused.
9 = Change tracking

But also pay attention to this note in the article:

The following properties will be removed in a future release of SQL Server: LogSize and PopulateStatus. Avoid using these properties in new development work, and plan to modify applications that currently use any of them.

EDIT: Corrected link to a newer page and added quote from the note

Related questions

Will indexing improve varchar(max) query performance, and how to create index

Firstly, I should point out I don't have much knowledge on SQL Server indexes. My situation is that I have an SQL Server 2008 database table that has a varchar(max) column usually filled with a lot of text. My ASP.…

Read More
Problems creating a full text index on a view

I have a view which has been created like this: CREATE VIEW [dbo].[vwData] WITH SCHEMABINDING AS SELECT [DataField1] , [DataField2] , [DataField3] FROM dbo.tblData When I try to create a full text index on it, like this: CREATE FULLTEXT INDEX …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More