Mega Code Archive
Creating a Full-Text Index
<![CDATA[
USE YourDatabase
GO
CREATE FULLTEXT CATALOG cat_YourName
CREATE FULLTEXT INDEX ON MyDocumentTable
(DocumentSummary, Document TYPE COLUMN FileExtension)
KEY INDEX PK_DocumentID
ON cat_Document
WITH CHANGE_TRACKING AUTO
]]>