Creating and Maintaining Databases

Administering Full-Text Features Using SQL Enterprise Manager

You can administer full-text indexes using the Full-Text Indexing Wizard or shortcut menus in SQL Server Enterprise Manager.

To enable a database for full-text indexing

Enterprise Manager

Enterprise Manager

Transact-SQL

To enable a table for full-text indexing

Enterprise Manager

Enterprise Manager

Transact-SQL

To enable a column for full-text indexing

Enterprise Manager

Enterprise Manager

Transact-SQL

To edit a full-text index on a table

Enterprise Manager

Enterprise Manager

Transact-SQL

To remove a full-text index from a table

Enterprise Manager

Enterprise Manager

Transact-SQL

To create a full-text catalog

Enterprise Manager

Enterprise Manager

Transact-SQL

To rebuild a full-text catalog

Enterprise Manager

Enterprise Manager

Transact-SQL

To rebuild all full-text catalogs in a database

Enterprise Manager

Enterprise Manager

Transact-SQL

To start and stop a full or incremental population of a full-text index

Enterprise Manager

Enterprise Manager

Transact-SQL

To check the status, tables, and schedules of a full-text catalog

Enterprise Manager

Enterprise Manager

To change or create a new schedule of a full-text catalog

Enterprise Manager

Enterprise Manager

To remove a full-text catalog from a database

Enterprise Manager

Enterprise Manager

Transact-SQL

To remove all full-text catalogs from a database

Enterprise Manager

Enterprise Manager

Transact-SQL

To clean up a full-text catalog on a server

Enterprise Manager

Enterprise Manager

Transact-SQL

To repopulate all full-text catalogs for a database

Enterprise Manager

Enterprise Manager

Transact-SQL

us.gif" ALT="" BORDER=0>Transact-SQL