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