London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

AI OnAI Off
Navigation [hide] [expand]
ARCHIVED This content is retired and no longer maintained. See the latest version here.

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

Last updated: Mar 31, 2014