Language

Home>Knowledge Base>Microsoft SQL Server 2008>How to create Full Text Indexing on SQL 2005 using SQL Server Management Studio

User Login

Information

Actions

Share With Others

How to create Full Text Indexing on SQL 2005 using SQL Server Management Studio

Note that this method will not work with SQL Server Management Studio Express.

Authenticate against the SQL Server and scroll to your database

Expand the Storage Folder, right click "Full text Catalogs," "Create New"

Enter only Full-text Catalog Name and owner fields and select its options

Right-Click created catalog

Select "Properties," select "Tables/Views," assign table/views to catalog

Click Ok