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


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
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.
Modification Type:MinorLast Reviewed:3/14/2005
Keywords:kbBug kbpending KB196903
©2004 Microsoft Corporation. All rights reserved.