According to BOL, if you include the IGNORE_DUP_KEY option on a CREATE UNIQUE INDEX statement (clustered or nonclustered), you will get a warning for duplicate key values but the non-duplicate rows will still be inserted. Without this option (as you know) you get an error and all inserts are rolled back.