Tried adding the ignore_dup_key clause also as in index below but somehow it errors out saying

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name................any suggestions please?

CREATE UNIQUE INDEX UNC_ABC ON ABC(col1,col2,col3) WITH IGNORE_DUP_KEY