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

ID: Q196903

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 49772 (SQLBUG_70)

SUMMARY

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 this to be a problem in SQL Server version 7.0.

Additional query words: col cols


Keywords          : kbbug7.00 
Version           : WINNT:7.0
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: April 21, 1999