Returns information about the specific ranges related to a full-text index population currently in progress.
|Column name||Data type||Description|
|memory_address||varbinary(8)||Address of memory buffers allocated for activity related to this subrange of a full-text index population.|
|parent_memory_address||varbinary(8)||Address of memory buffers representing the parent object of all ranges of population related to a full-text index.|
|is_retry||bit||If the value is 1, this subrange is responsible for retrying rows that encountered errors.|
|session_id||smallint||ID of the session that is currently processing this task.|
|processed_row_count||int||Number of rows that have been processed by this range. Forward progress is persisted and counted every 5 minutes, rather than with every batch commit.|
|error_count||int||Number of rows that have encountered errors by this range. Forward progress is persisted and counted every 5 minutes, rather than with every batch commit.|
On SQL Server, requires
VIEW SERVER STATE permission.
On SQL Database, requires the
VIEW DATABASE STATE permission in the database.