I could definitely write up something for a case study if you like. Once everything is finished I'll let you know.

I'm still working through the Replication parts. I can't decide...

OMG you are awesome, I was getting close, thanks for the help. I'll be going back into the client's place on Monday to add this part, i'll post the changes...

oh btw...this is what i have come up with so far on the merge article thing...of course this is like the 50th try...error is thrown on the .Add line.

'add to...

Yeah that's what I figured/hoped. So far I have it mostly done. I am successfully replicationg users to the reporting servers. I ran into a transaction log issue though, I...

Yeah that was my initial thought, but the client didnt like the idea so much, and as I need to get this done today, well whatever i can do for...

Yeah, the users will be added or changed on the first 8, and will need to be replicated to the reporting servers.

Yeah we looked at some software solutions out there, and none of them really had what we needed to do. I'm currently using sql-dmo scripting to do a lot of...

Yeah I looked into the Login Transfer Task, it doesn't transfer the permissions for me. Which I most definitely need. We have 8 production servers (each with a reporting server)...