Configuration using SQL on MSSQL 2005 Express Edition

  Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

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.

Page url: http://devnet.kentico.com/docs/devguide/index.html?configuration_on_mssql_2005_express_edition.htm