title: How to solve TFS error TF246021 and SQL Server error 500200 while checking in?
body: <p>I'm trying to check in a file, and one file (one and only one file) has a problem while being checked in. This file has been deleted many times and undeleted (due to a conflict in architecture and design) and now TFS throws this error:</p>
  
  <blockquote>
    <p>TF246021: An error occurred while processing your request. Technical
    information (for administrator): SQL Server Error: 500200</p>
  </blockquote>
  
  <p>As we saw the log file of the Event Viewer, the problem is:</p>
  
  <blockquote>
    <p>Violation of PRIMARY KEY constraint 'PK_tbl_PendingDelta'. Cannot
    insert duplicate key in object 'dbo.tbl_PendingDelta'.</p>
  </blockquote>
  
  <p>However, there is no pending changes in <code>dbo.tbl_PendingDelta</code>. In fact, this table is completely empty. What's wrong here? How can I solve this problem?</p>