因為發(fā)現(xiàn)對象名稱 'sys.syscolpars' 和索引名稱 'nc' 有重復(fù)的鍵，所以 CREATE UNIQUE INDEX 語句終止。重復(fù)的鍵值為 (ModuleDefID, 1300876397, 0) name id number

select * from sys.syscolpars where id=1300876397

SELECT name FROM sys.indexes WHERE object_id = OBJECT_ID('sys.syscolpars');

-- 首先，禁用索引

ALTER INDEX NC ON sys.syscolpars DISABLE;

-- 然后，重建索引

ALTER INDEX NC ON sys.syscolpars REBUILD;

-- 最后，重新啟用索引

ALTER INDEX YourIndexName ON YourTableName ENABLE;

EXEC sp_msforeachtable 'UPDATE STATISTICS ?';
-- 或者清理緩存
DBCC FREEPROCCACHE;
DBCC DROPCLEANBUFFERS;

-- 查看 sys.syscolpars 的索引信息
SELECT 
 i.name AS index_name,
 i.type_desc AS index_type,
 ISNULL(c.name, 'N/A') AS column_name
FROM sys.indexes i
JOIN sys.objects o ON i.object_id = o.object_id
LEFT JOIN sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
LEFT JOIN sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE o.name = 'syscolpars'
ORDER BY i.index_id, ic.key_ordinal;