Thanks for your help, but I found the problem.  It said there was a table that was owned by that user even though it didn't appear that way, so I'm still confused. ...

I tried that and I still get the same error.  I even ran sp_MShasdbaccess to see if there it had ownership of anything and it doesn't.

Thanks for the help, but I discovered the user error .  For some reason on one server the script required an osql statement but...

You're a legend.  Server had set up permissions on the security section but not the actual permission for the SQL login.

Thanks, it works perfectly now

I've tried backing up manually and it still doesn 't work.  I thought it might be the script so I ran it on a server that does backup properly and...

I'm trying to set up a maintenance plan.  The start up account has full access to the remote server.  I can't see the difference between the previous server which worked...

Yep!

"The backup directory is invalid. Are you sure that is what you want?"

Cool, thanks everyone.  I have just got a new SQL server and have moved my databases and still had the problem.

I did what Karl suggested and the file name was...

The path is fine, I've already checked that.  I was wondering if the old path was still being referenced in another table or database.

Thanks, that seemed to have worked.

All I'm doing is the optimisation checks through EM.  It's just a maintenance plan set up through the GUI.  I ran that script but I'm not sure what I should...

Thanks for that.

These are also the only reasons I found, I just thought there had to be more to it considering the cost involved.

Thanks for that

Thanks for that, you gave me the right idea. I tried this and it still didn't work.

update DT_Users

   set Firstname = A.givenName

     , LastName = A.sn

     , Company = A.company

    ...

O.K, I've tried a new tactic, but I'm still coming up with an error, here's the script followed by the error message.  Any help is grateful.

EXEC sp_addlinkedserver

'ADSI',

'Active Directory...