Thanks for all your input.

I am working on a solution based on your feedback but I have another question related to this.

FYI, at the time I first submitted the question...

Thank you all for your help and my apologies for not being clear.  Thank you especially, noeld.  Your answer does work in my case. 

I had just been so close...

Never mind.  I finally got it working about as good as it's gonna get.

Reporting Services currently does not allow hardly any chart appearance manipulation.  This is coming in SP1.  SP1 is currently scheduled for late June so expect it, at the earliest, sometime...

Because of time constraints and the limited size of my dataset, (against my wishes) I went ahead and built the SP using cursors.  It works fast and the amount of data...

I understand the problem with de-normalization.  I am not putting this in a permanent table.  I am putting this in a temp table in the SP so I can pull the...

I finally got around to testing my theory and I believe I was correct.

You can use the MOVE option with a differential backup.  You just have to be sure that...

This is common for me.  Just type in the name of the server and it will work.

Yes the full backup was made before the differential but as I am writing this answer I think I know what the problem is.  My "production" backup plan runs a full...

You are correct, I am running SP3.  I realized I didn't mention my version just before I got your response.  (Oops!)

I will take a look at your post about SP3.

Thanks...

mpinnow,

I am using the script you gave me but I just found out something this morning that you may not be aware of.

When the script is created, the lines to...

Are the logins that you are not getting passwords for Windows accounts.  If so, these types of logins do not have passwords, only SQL logins?

I use this for moving from...

I'm going to try this but I have a question about running this.  How do I set this up to run this ActiveX script?  I've never worked with scripts like...

Thank you, that was exactly what I was looking for.  I knew I had seen it somewhere before but I guess my search criteria wasn't good enough because I couldn't...

You might want to check out the following links from Microsoft about moving objects from one server to another.  I have used this before (and I'm actually in the middle...