Creating a full-text catalog in SQL Server using Management Studio

You can create a full-text catalog in SQL Server using the Management Studio GUI.

For more information about any of the SQL Server information covered below, see the appropriate topic in SQL Server Books Online.

Steps:

1. In SQL Server Management Studio's Object Explorer, click the plus sign (+) next to the appropriate SQL Server, then click the plus sign next to Databases.
2. Right-click the database in which the XML column will be created and click Properties.
3. Click Files under Select a Page on the left in the Database Properties dialog box.
4. Check Use full-text indexing in the page on the right if it is not already checked.
5. Click Permissions under Select a Page on the left.
6. Click the user who will own the XML column or the role to which they belong in the Users or roles list in the page on the right.
7. In the Explicit permissions for <user or role> list at the bottom of the page, scroll down until you see the References permission.
8. In the row for the References permission, check the box in the Grant column.
9. Click OK in the Database Properties dialog box.
10. Click the plus sign next to the database, then click the plus sign next to Storage.
11. Right-click Full Text Catalogs, then click New Full-Text Catalog.
12. Type a name for the full-text catalog in the Full-text catalog name text box. If you provide a name other than SDE_DEFAULT_CAT, you must modify the value of the XML_IDX_FULLTEXT_CAT parameter for the DEFAULTS keyword in the SDE_dbtune table.

    See Altering SERVER_CONFIG parameters after the geodatabase is created for information on changing the values of parameters in the SDE_dbtune table.

13. Set other properties for the full-text catalog as appropriate.

    For example, you can define the location on the file system where the full-text index files are stored or make the catalog the default full-text catalog for the database.

14. Click OK in the New Full-Text Catalog dialog box.

See Setting the full-text search engine language in SQL Server for information on setting the language to be used for linguistic analysis.