Sweet it works! Thanks, Lynn 🙂

Why would you even suggest that I am so unexperienced that I would have my machine acting as the server? That was extremely rude. Forget I even posted the question.

I tried scripting and it made the server freeze. Are there any implications with restoring an msdb to another server?

We had the same exact issue with two sql 2005 clusters when trying to install SP4. Both errored because it didn't like the service account. The one was due to...

It was part of a maintenance plan, and it was a little tricky to figure out because some databases were backing, but the larger one was the one failing.

Found the issue...it's an iscsi error. Gotta love left hand! There wasn't any pertinent info in the sql logs, event viewer, etc. that indicated the storage error. The main symptom...

It does show an error, but it just says the job fails. Very generic message.

No I haven't thought about SSIS...that's a great idea. Thank you!

I just need direction on how to commit N rows and move onto the next row without looping to the beginning of the table after the commit.

No the script is running, but it's taking over a week because it's looping back to the beginning of the table after committing 10,000 rows. In my original script I...

I'm using a loop to commit the insert after 10,000 rows are selected. TableA is around 800 million rows, so I have to commit after x amount of rows, so...

Thank you so much for your reply. The fix is this weekend, so I will update my post after that.

**UPDATE**

After researching, it may have errored because of the '@domain.local' after the service acct user name. This user is part of an AD group, so when the SP runs, it...

I found the error in the hotfix folder. Do I just have to add the service acct to the windows group? See below for error and acct info...

Error information:

Error 29512....

Thank you for your quick response