Msg 8152, Level 16, State 2, Line 1. Finding wich columns will be truncated : It's been asked hundred times, but I'm on a predicament, I was delegated to mantain a table from an external DB with the data I handle on my DB, what I'm faced now it's getting data from my DB to that table, the problem being the lengh of the values I have (data it's 90% equivalent at worst, but I also handle more precise data) and getting the classic `Msg 8152, Level 16, State 2, Line 1 Los datos de cadena o binarios se truncarían.`. I know I could check each column and comparing total lengh but we are talking about 130 columns and more than 6 joins on my procedure.

I did `SET ANSI_WARNINGS OFF` and found about 10 columns conflicting with the table (data shows clearly truncated values), but I still need to compare 120 columns with abount 4k rows.

With that being said is there a easier/less manual way to detect wich columns are raising errors?