Full-Text Catalog on SQL server 2008

To create Full-Text Catalog on the SQL server 2008, you must be using SQL Server 2008 Management Studio.

Just follow these steps:

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

Add Feedback