SQL Server 2008 Books Online (October 2009)
How to: Create a Full-Text Catalog (SQL Server Management Studio)

This topic shows how to create a full-text catalog by using SQL Server Management Studio.

Bb326035.note(en-us,SQL.100).gifNote:
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.

To create a full-text catalog

  1. In Object Explorer, expand the server, expand Databases, and expand the database in which you want to create the full-text catalog.

  2. Expand Storage, and then right-click Full Text Catalogs.

  3. Select New Full-Text Catalog.

  4. 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).

    Bb326035.note(en-us,SQL.100).gifNote:
    Full-text catalog IDs begin at 00005 and are incremented by one for each new catalog created.

  5. Click OK.

See Also

Concepts

Full-Text Catalog and Index How-to Topics (Full-Text Search)

Other Resources

CREATE FULLTEXT CATALOG (Transact-SQL)

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker