Knowledge Base

BUG: Full Text Search Fails with Unique Index on Multiple Columns

Article ID: 196903

Article Last Modified on 3/14/2005

APPLIES TO

This article was previously published under Q196903
BUG #: 49772 (SQLBUG_70)
BUG #: 49772 (Shiloh_bug)

SYMPTOMS

The SQL Server 7.0 Books Online documents that Full Text Indexing will only work on a table with an unique index on one column. This means that it will not work on a table that has an unique index on multiple columns.

WORKAROUND

For tables that do not currently have a single column unique index, add an IDENTITY column with a UNIQUE index or constraint to the table.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: col cols

Keywords: kbbug kbpending KB196903


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.