title: Too Many Rows Were Affected error on updating a Transact SQL linked table
body: <p>I am trying to update a linked table with this...</p>
  
  <pre><code>update openquery (LINKSERVERID, 'select tng_email from user_list where tng_id = 62873') 
    set tng_email = 'blah@blah.com';
  </code></pre>
  
  <p>... but I get the following error ...</p>
  
  <blockquote>
    <p>OLE DB provider "MSDASQL" for linked server "LINKSERVERID" returned message "Key column information is insufficient or incorrect.
    Too many rows were affected by update.".</p>
  </blockquote>
  
  <p>FYI: <code>tng_id</code> is the primary key.  </p>
  
  <p>How do I fix? </p>