August 24, 2012 at 7:39 am
Hello everyone,
I ran a script on my SQL Server it said it completed after 18 hours and 20 minutes but with errors, No Error Message or anything else for that matter usually I see a Line with some red characters telling me what line section of sql is not right. Nothing this time, I did put results to file, instead of the other option, because it would eventually run out of memory and crash anyway.
I have attached a screen shot and a .rpt file with the results in it. I would just like to know one thing where can I find the errors so I can repair the script and keep moving forward? I am just wondering where I can find the errors .....
Thanks,
August 24, 2012 at 7:44 am
Did you scroll through all the messages? There should be something there. Did you click the yellow bar?
August 24, 2012 at 8:12 am
Steve Jones - SSC Editor (8/24/2012)
Did you scroll through all the messages? There should be something there. Did you click the yellow bar?
Yes sir I did, If you look at the image above in my previous message, the info bar is there. I looked through the test_bulk_import.rpt file as well and there are no error messages anywhere, including in the sql logs, so I am miffed.
Thank you for your help,
August 24, 2012 at 8:32 am
It might not be something in red. I asked because the messages window in your image shows a long, small, scrollbar to the right, so there should be lots and lots of rows in there. You ought to cut/paste that entire set of information into a document and search for errors.
August 24, 2012 at 9:10 am
Steve Jones - SSC Editor (8/24/2012)
It might not be something in red. I asked because the messages window in your image shows a long, small, scrollbar to the right, so there should be lots and lots of rows in there. You ought to cut/paste that entire set of information into a document and search for errors.
Hello Steve,
Thank you for your help, I am sorry to be a bother but I am at a loss as I am new to the MS SQL DBA thing. Here is the entire window and I am all the way at the bottom, I will copy it all to a text editor and go from there.
August 24, 2012 at 1:42 pm
This is kind of odd it seems all the data got there the size is consistent and I checked a few of the district dbs and it seems to be fine. That is actually very scary to me. :w00t:
August 25, 2012 at 12:59 pm
If there was a warning or non-critical error, things might work.
SQL Server is rock solid on this stuff. I never worry about this losing data from the server. Now my code might be a problem.
It doesn't matter what you show at the bottom. I can't see the code, but it looks like you're looping somehow, which means that the error will be somewhere in the results. Not repeated at the end.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply