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