I trying to and a non-unique index to a table table in SQL Server 2005. I am getting the following error when I try to create it.
我试图和SQL Server 2005中的表表的非唯一索引。当我尝试创建它时，我收到以下错误。
Msg 1505, Level 16, State 1, Line 1 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.oe_pick_ticket' and the index name 'idx_pick_ticket_popup_wmms'. The duplicate key value is (1093066, N, N, N, , FBF, 100001, 1074359, 1118930).
消息1505，级别16，状态1，行1 CREATE UNIQUE INDEX语句终止，因为找到了对象名称'dbo.oe_pick_ticket'和索引名称'idx_pick_ticket_popup_wmms'的重复键。重复键值是（1093066，N，N，N，，FBF，100001,1074359,1118930）。
My create statement is as follows:
我的create语句如下：
CREATE NONCLUSTERED INDEX idx_pick_ticket_popup_wmms
ON oe_pick_ticket (invoice_no, delete_flag, direct_shipment, auxiliary, oe_pick_ticket_type_cd, company_id, location_id, order_no)
I have tried rebuilding the clustered/unique/primary key index and that didn't change anything. Does anyone know why I am getting this error and how to resolve it?
我已经尝试重建clustered / unique / primary key索引，但没有改变任何东西。有谁知道我为什么会收到此错误以及如何解决它？
1 个解决方案
#1
4
It turns out that I was able to figure this out on my own. I ran a DBCC CHECKTABLE on the table and there was an inconsistency. After that I ran it again with the REBUILD_REPAIR option and it fixed the primary key inconsistency.
事实证明，我能够自己解决这个问题。我在桌子上运行了一个DBCC CHECKTABLE并且存在不一致。之后，我使用REBUILD_REPAIR选项再次运行它，它修复了主键不一致。
#1
4
It turns out that I was able to figure this out on my own. I ran a DBCC CHECKTABLE on the table and there was an inconsistency. After that I ran it again with the REBUILD_REPAIR option and it fixed the primary key inconsistency.
事实证明，我能够自己解决这个问题。我在桌子上运行了一个DBCC CHECKTABLE并且存在不一致。之后，我使用REBUILD_REPAIR选项再次运行它，它修复了主键不一致。