Is there a way to view fail inserts to a SQL Server database? I am seeing that a number of my inserts are failing and I'd like to recover that data if it's possible.

1 Answer 1


No, SQL Server does not log failed transactions, and that data is gone.

You need to implement error handling. This would be a tip of the iceberg question, but here are some links for you to read.

Come back and ask a new question if you have some specific problem implementing your own logging of failed inserts.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.