This content is archived. See latest version here

Last updated: Mar 31 2014

Introduction

This document describes how to confirm the SQL Server Full text Index. This is done during configuration and deployment, in order to verify that the indexing is properly set up and is working.

Accessing and verifying the index

The index can be accessed from the SQL Server Management Studio. The details of the SQL Server Full-Text Catalog can be found under the ECF database Storage element. Check the Item Count under the connection properties.

SQL Server Full Text Index

If the Item Count equals 0 the index does not contain any information.

If Rebuilding the catalog from SQL Server Management Studio still results in an Item Count greater than 0, you can try resetting the Full Text Search Index by running the following commands:

            exec [mdpsp_sys_FullTextQueriesDeactivate]
            exec [mdpsp_sys_FullTextQueriesActivate]
            exec [mdpsp_sys_FullTextQueriesAddAllFields]
Without Full Text Search, search will be performed within fields that are in the product table (name, code) and in the SKU table (name, code, price, description).

See also

  • The Search section in the EPiServer CMS SDK

Do you have feedback on this documentation? Send an email to documentation@episerver.com. For development-related questions and discussions, refer to our Forums on https://world.episerver.com/forum/