I've run into quite a lot of issues specially when it comes to conversion errors:
convert(datetime, [fieldname]) or
SELECT CAST([field2] AS int).
Imagine a large select statement with 30+ conversion or cast functions, or a complex view with conversions, or even an insert statement on a field with wrong data type. I get so much headache trying to exclude fields one by one to find the troublemaker.
Is there a way to find out which field and/or value is causing the issue? How do people troubleshoot these without having to go through an arduous process of going field by field? Is there a log or information message that can help?