Thanks guys. I'll look into some of your suggestions. I ended up creating a new DB and restoring from backup to that DB. I copied the table that way. Maybe...

Thanks. I thought so but just wanted to see if there was an easier way to do it.

Ronnie

Thanks.

That was part of the solution. What turned out to be the main culprit was the security on the Analysis Services Data folder. When I check the permissions to that...

Remi - Good info!! I'll give that a try and track my results.

Thanks!!

Can you explain what you mean by execution plan?

If it's network related (which seems to be the obvious), it's only specific to the production server because the dev server is also on the same subnet in the same...

You must have Outlook configured as a MAPI mail client. I also have another server with Outlook running in MAPI mode and it also works without having to be opened....

Phil,

Thanks for the info. I guess I'm going to have to play with this to see if I can figure out what you have going on. I've been working with...

I LOVE THIS FORUM!!!!

Thanks Peter, that worked by installing the full backup first and then each incr with the NORECOVERY until I got to the last incr and used RECOVERY....

Thanks Bill. I appreciate the info.

Thanks Bill

I did realize how easy it is to edit a manual vs a maitenance plan. I appreciate the info. I guess you would recommend creating a manual bkup. Is that...

I'm not sure I totally understand what you mean when you say open a cursor and go through each line.

Thanks for the info. If I have multiple users, can I include them all in one script, maybe separated by a commas (,)?

Thanks to all. My migration was successful but one area I got into trouble with was the user ID's.

After detaching user databases and the msdb database and moving them...

Scott, can you explain step number 2? When you say "extracting scripts", what exactly do you mean.

thanks,

Ronnie