To create Full-Text Catalog on the SQL server 2008, you must be using SQL Server 2008 Management Studio.
Just follow these steps:
- Authenticate to SQL Server 2008 and scroll to your database
- Select the Storage Folder, then right click on "Full text Catalogs" -> "Create New"
- Enter only the Full-text Catalog Name and owner fields, then select its options
- Right Click on the created catalog
- Next, Select "Properties," -> "Tables/Views" -> assign table/views to catalog
- Click Ok
Article ID: 284, Created: 4/24/2009 at 9:39 AM, Modified: 4/25/2009 at 11:28 AM