Create FULLTEXT Catalog and Index in SQL Server

5/19/2013 7:57:38 PM

Create a full text catalog and index in SQL Server 2012 (using SQL Management Studio).

--1. Select the database that the catalog should be on.
--2. Create a Fulltext Catalog
	
	CREATE FULLTEXT CATALOG MyFullTextCatalogName_FTS
	WITH ACCENT_SENSITIVITY = OFF
	
--3. Create a Fulltext Index
	
	CREATE FULLTEXT INDEX ON TableThatContainsDataToCatalog
	([Col1] LANGUAGE 1033, [Col2] LANGUAGE 1033)    --1033 refers to English Language, only 1 column required
	KEY INDEX PK_TableThatContainsDataToCatalog     --Primary Key name of table
	ON MyFullTextCatalogName_FTS
	WITH STOPLIST = SYSTEM							--Uses system stop word list