BUG: "Do You Want to Delete This Index" Message When Creating Index (198106)



The information in this article applies to:

  • Microsoft SQL Server 7.0

This article was previously published under Q198106
BUG #: 46869 (SQLBUG_70)

SYMPTOMS

When attempting to create an index in the Design Table mode from within SQL Server Enterprise Manager, you may receive the following error message if you have not yet selected the column(s) on which you want to create the index:
Do you want to delete this index

WORKAROUND

When creating an index, ensure that you have chosen the column(s) on which you want to create the index. A column must be specified in order to create an index.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Modification Type:MajorLast Reviewed:10/15/2002
Keywords:kbBug KB198106