Setting Up Full Text Index

1. Make sure database is setup for full text index.

select name, DATABASEPROPERTY(name,'IsFulltextEnabled')
from master..sysdatabases where dbid > 4

select fulltextserviceproperty('isfulltextinstalled') 

--EXEC sp_fulltext_database 'enable'

2. Create Catalog

Database -> Storage -> Full Text Catalogs -> New Full-Text Catalog

3. Define Full-Text Index

Database -> Table -> Full-Text Index -> Define Full-Text Index

Note: Make sure the table has at least one unique index.

4. Populate Catalog

Database -> Table -> Full-Text Index -> Start Full Population

Note: Might want to create a job to run on a schedule time.

Note: Might want to remote desktop on to server, open up SSMS on server to configure the full text index.