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.
In This Topic
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).
.gif)
Note
|
|
Full-text catalog IDs begin at 00005 and are incremented by one for each new catalog created.
|
-
Click OK.
[TOP]
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
|
[TOP]
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.
[TOP]
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.
[TOP]
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.
[TOP]
See Also