title: Can I set ignore_dup_key on for a primary key?
body: <p>I have a two-column primary key on a table. I have attempted to alter it to set the <code>ignore_dup_key</code> to on with this command:</p>
  
  <pre><code>ALTER INDEX PK_mypk on MyTable
  SET (IGNORE_DUP_KEY = ON);
  </code></pre>
  
  <p>But I get this error:</p>
  
  <p><code>Cannot use index option ignore_dup_key to alter index 'PK_mypk' as it enforces a primary or unique constraint.</code></p>
  
  <p>How else should I set <code>IGNORE_DUP_KEY</code> to on?</p>