Configuration on MSSQL 2005 and 2008

1.Start Microsoft SQL Server Management Studio.
 
2.Locate your database with Kentico CMS objects, unfold Storage, right-click Full Text Catalogs and choose New Full-Text Catalog.
 
clip0401
 
3.On the New Full-Text Catalog dialog, enter Full-text catalog name KenticoCMS and click OK.
 
clip0402
 
4.Right-click the newly created KenticoCMS full-text catalog and choose Properties. On the Full-Text Catalog Properties dialog, choose the Tables/Views tab.

 

5.Assign the CMS_Attachment table to the catalog, check the box next to the AttachmentBinary column, set the Language for Word Breaker to English or other value and set the Data Type Column to AttachmentExtension as shown on the following figure and click OK.
 
clip0403
 
6.Sign in as administrator and go to Site Manager -> Development -> Document types -> Root and edit the searchattachments query. Uncomment the following query:
 

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 )