Microsoft KB Archive/196903

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

Article ID: 196903

Article Last Modified on 3/14/2005

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.