Getting duplicate key error: See log where the INSERT query error is

[riahc3]

I have a bunch of insert querys running and some of them fail with a duplciate entry.

I want to see a log where it says "Error: Duplicate key" and that tells me the EXACT INSERT query that fails so I can see what keys are duplicated.

Thanks

[minitauros]

Well, can't you loop through your queries and validate that the correct data is being inserted? You could break the loop when the error occurs, showing you which data is generating the error.

[pritaeas]

http://www.lucasnotes.com/2012/10/querying-sql-server-error-log.html

http://www.brentozar.com/archive/2013/08/what-queries-are-failing-in-my-sql-server/

http://dba.stackexchange.com/questions/35015/log-all-errors-in-queries

[Kyle Wiering]

If you are inserting programmatically, you can determine the query failed then log the error and the query that you built to be sent to the server. Of course, you might be inserting a large collection, in which case you will need to use pritaeas' answer.