I have a non-unique index on t(c1,c2). There combination of c1,c2 is not unique and there are some duplicate values.
I want to create a unique constraint on t(c1,c2) which will:
- NOT Create a new UNIQUE index but will use the existing non-unique index
- NOT validate the existing data in the table (like in Oracle we have NOVALIDATE clause).
How i can do that? I am using SQL Server 2005.