I think altering the table and adding a constraint with NO CHECK option is what you need.

ALTER TABLE tblTable WITH NO CHECK ADD CONSTRAINT uqConstraint UNIQUE

Regards,

Sony Antony.