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
Leave a Comment