In this article we will describe to create Full text search in SQL Server 2008 through SQL Server management studio. To create a full-text catalog:\r\n

\r\n
1. Launch SQL Server management studio 2008

\r\n

2. Connect to SQL Server

\r\n

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

\r\n

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

\r\n

5. Select New Full-Text Catalog.

\r\n

6. In the New Full-Text Catalog dialog box, specify the information for the catalog that you are re-creating

\r\n

7. For more information, see New Full-Text Catalog (General Page)

\r\n

8. Click OK.

\r\n

\r\n

\r\n\r\n