Chris, thank you, I am looking at it now. I got further yesterday after upgrading the second server to enterprise edition but then encountered new difficulties. I may be back....

Greetings, I discovered the source of my difficulties. The destination server is running Standard Edition and Enterprise Edition is required. We will be upgrading. Thanks.

As I understand registration they are. When I open the SQL Server group I am able to see the remote server and the database on the remote server. This is the...

Thank you both.

That worked, thank you.

Greetings, I am logged on to the server, I bring up the query analyzer and execute the command exec sp_changeobjectowner 'view_name', 'dbo'; and receive the following message...

Server: Msg 15001, Level...

nother question, if I back up the database on the source server is it necessary to

precreate the database on the destination server or will the restore also create the...

If I detach the files and copy them I assume I then merely reattach the files to the

source database in order to retain the database at the source, is...

THanks to all who replied. I will do some testing.

Chris, I did see the link referenced. Thanks very much for sharing your code. I do appreciate it.

THanks to both of you for your replies. CHris, I would be very interested in seeing the script you spoke of. Thank you.

Thanks to all who replied. This leads to a follow up question. In that master, model and msdb are in simple recovery mode is there anything necessary to take this...

Thank you both. I was able to delete the job.

Steve, it turns out that at some point I created it by hitting the tools -> backup database menu. Now I would like to diabel/delete this backup plan but am...