title: Cannot insert explicit value for identity column with no primary key
body: <p>I have a table:</p>
  
  <pre><code>Ratings
  ---
  PersonId int FKEY
  FormId int FKEY
  Rating int (NULLABLE)
  </code></pre>
  
  <p>When I perform this query:</p>
  
  <pre><code>INSERT INTO Ratings (PersonId, FormId)
  SELECT p.PersonId, f.FormId
  FROM People p, Forms f
  </code></pre>
  
  <p>I get this error: </p>
  
  <blockquote>
    <p>Cannot insert explicit value for identity column in table 'Ratings' when IDENTITY_INSERT is set to OFF.</p>
  </blockquote>
  
  <p>At one point I had accidentally set the two foreign key columns to a composite primary key, and I fear there may be a form of data corruption.  What can I do to remedy this or to repair my issue in the long-run?</p>