Article ID: 168659
Article Last Modified on 2/22/2005
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q168659
BUG #: 15660 (NT: 6.5)
SYMPTOMS
In SQL Server 6.5, you will receive a message 1505 when duplicate values exist in a column and you attempt to create a unique index on that column. In versions of SQL Server 6.5 earlier than Service Pack 3, the message was a bit confusing:
However, beginning in SQL Server 6.5 Service Pack 3, SQL Server indicates the duplicate value that the CREATE INDEX command aborted on:
RESOLUTION
Identify the duplicate column values that make up the index and remove them before issuing the CREATE UNIQUE NONCLUSTERED INDEX statement.
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been fixed in Service Pack 3 for Microsoft SQL Server version 6.5.
MORE INFORMATION
For more information, see the CREATE INDEX statement in the T-SQL Reference Manual or the SQL Server Books Online.
Keywords: kbbug kbfix kbusage KB168659