I had to reboot my system, so I saved my .sql and .the output to a .rpt file.
The .rpt has several errors in it:
(6867 row(s) affected)
(315 row(s) affected)
(464 row(s) affected)
(33 row(s) affected)
(18 row(s) affected)
(4 row(s) affected)
Msg 8152, Level 16, State 4, Line 20
String or binary data would be truncated.
The statement has been terminated.
plus many more....
Now I need to try to load this file into results pane and the .sql file so I can double click on the errors and see the exact sql. I noted that when I did click on it, even though it says Line 20 for the sql, it really was not line 20. How do to get these files loaded together so I can double click and get to the sql that is erroring out?