title: Foreign Key Constraint Violation MS-SQL: useless error without details
body: <p>Violating a simple foreign key contraints in MS-SQL generates following useless error-message: </p>
  
  <pre><code>Error: The INSERT statement conflicted with the FOREIGN KEY constraint 
  "FK_employee". The conflict occurred in database "AgentAndAgency", table "dbo.employee", column 'id'.
  SQLState:  23000
  ErrorCode: 547  
  </code></pre>
  
  <p>Missing is the detail, which key is causing the foreign key contraint, so, e.g. PostgreSQL would say in the same situation:  </p>
  
  <pre><code>Error: inserting into table employement violates foreign key contraint- „FK_employee“
  Details: key (employee_id)=(958980) does not exist in table „employee“.
  </code></pre>
  
  <p>MS-SQL does not provide this information, which makes it completely useseless (I'm bulk-inserting thoundsands of records). </p>
  
  <p><strong>Question</strong>: how can I make MS-SQL tell me at least one missing key? </p>