Hello everyone,
I've got an interesting issue. I'm trying to trace a truncation error from a stored procedure using table-valued parameters. The stored procedure itself never runs - I get "String or binary data would be truncated." prior to the RPC call. The issue is a C# application sending a table-valued parameter that has some columns longer than the defined type in my database.
I've been able to trace this on occasion in Profiler and this traps the content of the database call, letting me search the data for long strings. However, right now the only thing I am seeing in the Profiler window is "-- Encrypted text". Am I exceeding some sort of trace data limit? My stored procedures are not encrypted.
Thanks in advance for any tips you can give me!