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

ID: Q198106

The information in this article applies to:

• Microsoft SQL Server version 7.0

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          : SSrvEntMan kbbug7.00 
Version           : WINNT:7.0
Platform          : winnt
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: January 1, 1999