February 12, 2007 at 6:33 am
Hi All
I have a sp thats been deployed on all my servers. When I try to execute the sp on my servers, I get the following error msgs, varying from server to server:
System cannot find file specified
Logon failure:unknown username or bad password
Access is denied
The sp gets triggered when the job fails; giving the servername,jobname,status,date
Any help would be appreciated SO MUCH!!
Anchelin
February 12, 2007 at 8:14 am
you'd really have to post the code for anyone to help -- but --- to resolve proc issues I normally lift the code into QA and run it manually, that way I can jump to where the error occurs.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply