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'

Please note: Similarly to configuration on MSSLQ 2005, you need to go to Site Manager -> Development -> Document types -> Root -> <edit the searchattachments query> and uncomment the following query to be able to run full-text search.

SELECT view_cms_tree_joined.*, view_cms_tree_joined.NodeName AS SearchResultName

FROM cms_attachment

INNER JOIN view_cms_tree_joined on view_cms_tree_joined.DocumentID = cms_attachment.AttachmentDocumentID

WHERE NodeAliasPath LIKE @NodeAliasPath

AND

([AttachmentName] Like N'%'+ @Expression + N'%' OR FREETEXT(attachmentbinary, @expression))

AND @SiteName = SiteName AND (@DocumentCulture = DocumentCulture OR @DefaultCulture = DocumentCulture )