ishaan99 (3/10/2009)
Tried adding the ignore_dup_key clause also as in index below but somehow it errors out sayingThe 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
What are you trying to do here?You cannot create a unique index if there are duplicate entries no matter where IGNORE_DUP_KEY is off or on.