Ok, I thought this one would be easy.
I have a stored proc: master.dbo.restore_database_foo
This is on database server B.
Database server A backs up database foo on a daily basis as a scheduled
task.
What I wanted to do was, at the end of the scheduled task is then call the
stored proc on B and restore the database.
If I go into Query Analyzer and log into database A, then exec
b.master.dbo.restore_database_foo works.
But if I take the same command and make it part of the scheduled task it
fails.
Error is:
OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
[SQLSTATE 01000] (Error 7312). The step failed.
To me this seems like a permissions issue, but nothing I've tried seems to
have helped.
Suggestions?
--
--
Greg D. Moore
President Green Mountain Software
Personal:
http://stratton.greenms.com