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

Microsoft SQL Server 2008

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.
  1. Authenticate against the SQL Server and scroll to your database
  2. Expand the Storage Folder, right click "Full text Catalogs," "Create New"
  3. Enter only Full-text Catalog Name and owner fields and select its options
  4. Right-Click created catalog
  5. Select "Properties," select "Tables/Views," assign table/views to catalog
  6. Click Ok

Add Feedback