SQL Server - new unique index on one of my database tables in SQL Server 2008

Asked By dev rathore on 10-Sep-12 07:27 AM

I am trying to add a new unique index on one of my database tables in SQL Server 2008. This is an existing table and the column where I want the unique index already has some duplicate values.

Can I set up a unique index for that column? If so, how?

Peter Bromberg replied to dev rathore on 10-Sep-12 11:24 AM
No, for a unique index there cannot be duplicate column values.