There is no logging for insert/update/deletes. You can enable SQL Trace, but you are potentially asking for a ton of data.

What are you trying to accomplish? Typically there isn't a "failure" of a select/insert/update/delete on a regular basis.