Oh and by the way, the user that executed the job is the same user I have assigned to start the SQL agent service. That makes sense. I don't know why...

GOOD Information!!!

Sorry it wasn't a simple anwser, but this has really helped me understand.

Thanks you all!

Ronnie

I wanted to follow-up with the resolution that worked for me.

Basically, I installed the latest MDAC and service pack and rebooted the server. That seemed to have cleared up the...

I've re-installed the SP and rebooted and I still got the same error. I have a development server with the same instance running on it. Based on the error, do...

Pete - You are my hero!!

Thank you very much. Your instructions worked perfectly. One thing I relized I had to do for some reason is stop the default SQL instance...

Thanks for getting back to me on this.

The update is failing right after it trys to run the replsys.sql

Here are the last few lines of the sqlsp.log file:

16:46:52 Begin ServPriv...

Thanks for the info.

The problem that we are having is when ever we bring up the service, the system becomes unstable. We wanted to try to reconfigure the parameters...

Has it ever worked?

I had a similar problem and all I did to correct it was to go into the properties of SQL Agent and reset the mail settings...

Thanks Guys!

I guess it also depends on the size of the database as well; huh? I have a server running about 6 different server instances and there is an average...

Thanks Brian - I actually brought the book and will check it. Thanks again.

Yes - I have a scheduled job that reindexes the database on a weekly bases.

I questioned if she could run her app bypassing Citrix and was told no. But...

Thanks guys for the info. The only thing that bothers me about all this is the vendor said that they tested the same import (it's probably an insert) function and...

Thanks guys.

So backups to files are better??

I guess I need to make some changes. I've read documents that discuss backups and the importance, but I haven't found a good...

Thanks guys. I guess I've been doing it all wrong. I guess one of my primary reasons for doing so was to preserve disk space. Since the log file was...

Thanks guys.

So basically, I need to leave the logs alone? I'll research that information that was suggested. The purpose of my question to the forum was to hopefully get some real world experience...