Don't change it, SSRS creates the DB's in that collation so leave it in that collation, otherwise you risk breaking the SSRS application.

Why not just restore a copy from backup instead of using the copy database wizard?

Also if your using the wizard, you need to ensure that the SQL Agent account has...

ALTER DATABASE msdb SET MULTI_USER

http://sqldbpool.com/2010/12/18/different-types-of-sql-server-database-access-mode/ - Remember google is your friend.

Not that I am aware of, otherwise you will get the whole list of Control.Value in your header if you remove the first clause.

Well your expression is incorrect then

If you want the data set value to appear in the header then that needs to go as part of your header part or as...

Well I can't see nothing wrong with the expression.

Can you zip up the solution and the report so I can take a look?

Post the full expression

The only truely supported broswer for SSRS is IE, if you want everything to work as it should do, then you need to use IE.

Remember that SSRS is a MS...

Use an expression on the visable property of the header part.

If the data in the data set is right set it to True, if not set it to false

=IIF(Fields!Column.Value "DATASETNAME"...

I have not seen any issues in our environments where the RS and RSTempDB are on the same server as production.

We have SSRS installed on a dedicated box, but the...

does the account running the datasource have access to run the proc?

What ERP system is it?

This should help

http://support.microsoft.com/kb/231619

has the drive been added as a dependency to the application group where SQL sits?

Remove the sets from your sp_send_dbmail call, also read the documentation on the procedure, it will tell you how to make a successful mail call.

http://msdn.microsoft.com/en-us/library/ms190307.aspx