SQL Server Profiler - Error Details

Question

I enabled the whole error-section but it only says smth like:

Exception: Error converting data type nvarchar to datetime.

It's good to know, but what's about the details? I wanna know what particular query caused this and all the other verbose information. Is there a way to attain this?

I checked SQL Statement Starting/Completed, SP Starting/Completed etc. What more should I enable to make it show more details I need?

Answer 1

If you have the ability to, when you begin your profile session, select the TSQL_REPLAY template. This will provide all the details you need.