|
Configuration using SQL on MSSQL 2005 Express Edition |
|
|
|
|
|
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 ) |
Note: It is not necessary to uncomment the query if a Smart search web part is used for search. In that case the Search in attachments option in Smart search dialog with results has to be checked.
