sql-server - 如何定义全文索引重建是否完成？

Question

需要重建mssql全文索引。
问题是 - 我需要确切地知道工作何时完成。因此 - 只需调用:

ALTER FULLTEXT CATALOG fooCatalog
REBUILD WITH ACCENT_SENSITIVITY = OFF  

不起作用或者我做的事情有点错误。 :/

有什么想法吗？

Answer 1

您可以通过查询indexing properties来确定全文索引的状态。像这样:

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

但还要注意文章中的这一注释:

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.

编辑:更正了指向新页面的链接并添加了注释中的引用