Hi there,

Between the drop of the index and the creation of the index was there any activitie on the table?

You can identify the duplicated records by performing the folloing query

SELECT <List of columns included in the Unique INDEX>, count(*)

FROM dbo.tblone

GROUP BY <List of columns included in the Unique INDEX>

HAVING COUNT(*) > 1

José Cruz