You cannot disable UNIQUE constraints. Your inserts are violating the unique constraint AK_Item_Parts_Sku. If you need to insert duplicate keys for some reason, you would have to drop the constraint, not disable it.
No, you cannot do that. If you drop the constraint, then insert the duplicate row, and then try to recreate the unique constraint while the are duplicate keys in the table, you will get an error when attempting to create the constraint and the constraint will not be created.
You cannot ever have a unique index and duplicate keys. If you ever found a way to do that that would be a MAJOR bug in SQL Server.
Sign in to comment