That's exactly the sort of concept I was missing - that gives me something worth looking into, many thanks.

Thanks - I am a bit stuck at the moment and your list is pretty much where I look.

I will admit my queries are not going to be perfect, for...

if your machine is case sensitive I would check the code carefully.

We also used some of this code as the basis for our current routine - for a production install...

Ah, that simple 😀

Maybe today is looking so bad after all.

Your assistance much appreciated.

Ah, that simple.

Is there a way of moving all the existing reports, subscriptions and data sources or is that manual?

I spent a year going around the world with a backpack having been working for 3 years following university, it is an amazing experience although at job interviews I have...

Was the active an genuine UAT environment for end users? I've always been led to believe that UAT required normal license and developer could only be used for actual developer...

I actually enjoy working hard but have a life outside of work so am keen to work hard and not work long.

Sometimes everything goes pear shaped and I have...

Thanks guys, this is what cracked it for me (first green answer) : http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/300add38-39e5-4053-83d8-67831b499143/

I suspect someone has altered our security settings thus breaking my IIS config.

I still...

The rollback might take as long to rollback as it took to go forwards, however, we have experienced an issue where we had to restart the SQL service (oh yes)...

You can buy additional CALs so no problems there.

Not sure what Microsoft counts as one CAL use - have a rummage on their site for info about licensing, I'm...

I'm not au fait with scripts but within SSIS I added the following before my month and date fields :

((dt_wstr,2)len((dt_wstr,2)month(getdate()))=="2"?"":"0")

which is saying "if the month is 2 chars long...

They got it wrong because they are using 2005 & the question doesn't specify the version and I suspect most businesses are still using 2005 for production systems.

I'd be happy as long as the business were realistic about the hardware requirements - my first job was in a business with a 250mb Oracle database on a 20mhz...

Thanks chap - code probably too embarassing to post!;-)