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