How to figure out which string or binary data would be truncated?

Vote count:

1

I have a stored procedure which works most of the time, but every now and again, I get an error message:

Msg 8152, Level 16, State 2, Line 98
String or binary data would be truncated.
The statement has been terminated.

How do I figure out which data string is causing this issue?

asked 3 mins ago

oshirowanen

1,366

How to figure out which string or binary data would be truncated?