- Full-Text Catalog Displays the name of the full-text catalog
with which the full-text index is associated. For a SQL Server
2008 database, a full-text catalog is a virtual object that does
not belong to any filegroup; it is a logical concept that refers
to a group of full-text indexes. However, when a database is
upgraded from SQL Server 2005 or SQL Server 2000, the full-text
catalog continues to reside in a filegroup. Displays the name of
the database in which the full-text index resides. Displays the
name of the table on which the full-text index is defined. -
Full-Text Index Key Displays the name of the full-text index
key, which is a unique index on a single column of the table. -
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 autom