Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

.rpt file Expand / Collapse
Author
Message
Posted Tuesday, November 13, 2012 8:25 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 8:33 AM
Points: 246, Visits: 791
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?




Post #1384125
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse