I used a utility, RSScripter, but ended up doing permissions manually as it was actually quicker in our case. Wish you luck!

The reports and subscriptions just completed! I've got a little work to do as we are changing domains too so wish me luck!

Were you able to upgrade your reports successfully from SQL Server 2005 SP2 to SQL Server 2008 R2?

Question for the gurus - traditional thinking over the years - you never defrag at the o/s level as it can cause issues for SS and you defrag from within...

I'm coming into this thread a little late but would you clarify your last comment, Joe? How do you handle memory mapping - by setting affinity? Do you...

I think I ran across this myself. Create the new db (db B) making sure you use the tablespace name of db A. Then restore to db B...

Hi all,  Sounds like lots of experience out there.  I'm looking for some suggestions for a standard install to our production/DR/Dev/Test and UA servers. Any gotchas with installing/supporting the Activity Logging...

I agree with jloesch for all the reasons specified and think the correct answer should be modified using the reasons specified.  Way to go jloesch!!!!

Thanks for the great information. I'll implement the dbcc sqlperf(waitstats) right away. How cool to have such a great impact on your environment. Sounds like your boss was very...