Confirming SQL Server Full-text index (Commerce 7.5)

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.

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).

Confirming SQL Server Full-text index

Introduction

Accessing and verifying the index

See also