SQL Server Full Text Search - Quick Setup

You should be able to browse in your browser to this route in a project: Search/CreateFullTextIndex. However, this may not work due to permissions.

You can use SQL Management Studio (look under a database under Storage > Full Text Catalogs and add one).

Or just run all these commands in the query window, which is definately the most reliable and quickest way.

sp_fulltext_database @action='enable'
go
CREATE FULLTEXT CATALOG fulltextCatalog AS DEFAULT
go
sp_configure 'show advanced options', 1
go
RECONFIGURE
go
sp_configure 'transform noise words', 1
go
RECONFIGURE
go
CREATE FULLTEXT INDEX ON Page(Title,SubTitle,BodyTextHtml,NavTitle,MoreTextHtml,Introduction) KEY INDEX PK_Page WITH CHANGE_TRACKING AUTO