Knowledge Base

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

Article ID: 198106

Article Last Modified on 10/15/2002

Microsoft SQL Server 7.0 Standard Edition

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.

Additional query words: SEM EM MMC GUI ent man entman

Keywords: kbbug kbpending KB198106