Alternatively Enterprise manager would be helpful.

On the restore screen replace the default which is the file location from which the .BAK was  created with the new file location...

Mike

For some reason the user had rights revoked from the database in question.

Once the rights were given all seems to work fine

Let your the remainder of your day be...

when default database is master login works just fine when a user database is chosen then "Cannot  open user default  database Login failed" comes up

As usual your input is greatly appreciated

Mike...

Sean

I enjoyed your article but this just seemed out of place

I'd just found him in my living room floor in his undies with my dog and a jar of...

The schedule has been  changed  on the master server .Started/restarted the agent on both servers and even deleted the job entirely on the master server but it still runs on the...

Thanks to all who responded Veteran,s answer worked out well for me.

I am currently looking into changing the maximum number of allowed errors

in DTS

Mike

Thank you for your response

If anyone has done something in those lines and wants to share that will be appreciated

Thanks

Mike

Thanks for your responses.

Before exploring the newer options.You  may be interested to know that  I have outlook installed.xp_startmail runs just fine and xp_sendmail runs for hours with no feedback .

Any response...

Congratulations Frank

Keep up the good work

Michael

#3 is  is great with a #1 size .The spaces could be trimmed

and all the words have the same size except caps

Mike

Thanks for the responses people .OnceI hit post it dawned on me that perl could be useful

Michael

Got the needed help .Thank you all for the great responses

Mike

Thanks a million for your reply...

In oracle Break on would perform such a function, this will list

all the different permissions  but can group them by fixed roles

if you so ask

Hope this...

You may want to check out  sp_helptext on books online

Michael

Did you find a way out ..........

Michael