SQL Server Profiler - Error Information

Question

I have included the entire error section, but it only says smth like:

Exception: Error converting data type nvarchar to datetime.

Good to know, but what about the details? I want to know which particular request caused this and all other detailed information. Is there any way to achieve this?

I checked the SQL expression Start / End, Start / End SP, etc. What else needs to be included to show more details that I need?

Answer 1

If you have the opportunity, when you start your profile session, select the TSQL_REPLAY template. This will provide you with all the necessary information.