Create and Manage Full-Text Catalogs
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.
Creating a Full-Text Catalog
To create a full-text catalog
In Object Explorer, expand the server, expand Databases, and expand the database in which you want to create the full-text catalog.
Expand Storage, and then right-click Full Text Catalogs.
Select New Full-Text Catalog.
In the New Full-Text Catalog dialog box, specify the information for the catalog that you are re-creating. For more information, see New Full-Text Catalog (General Page).
Note
Full-text catalog IDs begin at 00005 and are incremented by one for each new catalog created.
Click OK.
Viewing the Properties of a Full-Text Catalog
Transact-SQL functions such as FULLTEXTCATALOGPROPERTY can be used to obtain the value of various properties related to full-text indexing. This information is useful for administering and troubleshooting full-text search.
The following table lists the properties that are related to full-text catalogs.
| Property | Description | Function |
|---|---|---|
AccentSensitivity |
Accent-sensitivity setting. | FULLTEXTCATALOGPROPERTY |
ImportStatus |
Whether the full-text catalog is being imported. | FULLTEXTCATALOGPROPERTY |
IndexSize |
Size of the full-text catalog in megabytes (MB). | FULLTEXTCATALOGPROPERTY |
ItemCount |
Number of full-text indexed items currently in the full-text catalog. | FULLTEXTCATALOGPROPERTY |
MergeStatus |
Whether a master merge is in progress. | FULLTEXTCATALOGPROPERTY |
PopulateCompletionAge |
Difference in seconds between the completion of the last full-text index population and 01/01/1990 00:00:00. | FULLTEXTCATALOGPROPERTY |
PopulateStatus |
Populate status. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. |
FULLTEXTCATALOGPROPERTY |
UniqueKeyCount |
Number of unique keys in the full-text catalog. | FULLTEXTCATALOGPROPERTY |
Rebuilding a Full-Text Catalog
To rebuild a full-text catalog
In Object Explorer, expand the server, expand Databases, and then expand the database that contains the full-text catalog that you want to rebuild.
Expand Storage, and then expand Full Text Catalogs.
Right-click the name of the full-text catalog that you want to rebuild, and select Rebuild.
To the question Do you want to delete the full-text catalog and rebuild it?, click OK.
In the Rebuild Full-Text Catalog dialog box, click Close.
Rebuilding All Full-Text Catalogs for a Database
To rebuild the full-text catalogs for a database
In Object Explorer, expand the server, expand Databases, and then expand the database that contains the full-text catalogs that you want to rebuild.
Expand Storage, and then right-click Full Text Catalogs.
Select Rebuild All.
To the question, Do you want to delete all full-text catalogs and rebuild them?, click OK.
In the Rebuild All Full-Text Catalogs dialog box, click Close.
Removing a Full-Text Catalog from a Database
To remove a full-text catalog from a database
In Object Explorer, expand the server, expand Databases, and expand the database that contains the full-text catalog you want to remove.
Expand Storage, and expand Full Text Catalogs.
Right-click the full-text catalog that you want to remove, and then select Delete.
In the Delete Objects dialog box, click OK.