Configuration using SQL on MSSQL 2005 Express Edition

If you cannot use management console for full-text search configuration, you can use the following SQL commands:

-- Activate Full text Searching on PDF on Microsoft SQL 2005

sp_fulltext_service 'verify_signature', 0

sp_fulltext_service 'load_os_resources',1

-- Create Full Text catalog

sp_fulltext_catalog 'MyKenticoCMSCatalog','create'

-- Add Full Text catalog to table

sp_fulltext_table 'CMS_Attachment','create','MyKenticoCMSCatalog','PK_CMS_Attachment_02FC7413'

-- Add Index to table column

sp_fulltext_column 'CMS_Attachment','AttachmentBinary','add',NULL,'AttachmentExtension'

-- Populate the catalog

sp_fulltext_table 'CMS_Attachment','start_full'