1) have a look at the Methods of the String Class, Trim is in there as well as all the other usual ones.

2) I am fairly sure that you...

As mentioned there are many options , I wouldn't discount the SSIS package for being too complex it can be fairly straight fowared to setup

a column that can handle unicode will have a n prefix on the datatype

e.g. nvarchar, nchar

collation refers to the sorting and matching of character data.

I would recommend studying for it yourself with the help of one of the books, and then book an exam with a second shot. So you can take...

Report builder comes with SQL 2008(R2) if you are running in Sharepoint integrated mode then you need to setup a library with type of Reports and then when...

you should only need One (%) in the Like not Two next to each other (%%)

have a look in the report server execution log there should be a more detailed error in there to give you an idea of what could be causing the problem..

you could use SSIS to deploy them same xmla cube code, to both servers and then set this up as a job that you can execute to process the cube...

Is the email section of the reporting server configuration manager setup correctly?

then either use SSIS, just set up the external server as a destination so you won't actaully store the packages there so you shouldn't get the error.

or,

use...

backup the database as normal,

find the .bak file and copy it or ftp it to the other server.

you also may want to zip the .bak with a password for...

c# is not going to work in SSIS 2005.

have a look at the snapshot agent job on your distribution server, there should be some errors in the log saying why it can not start.

no, i have come across the same misconception as well even from direct bosses that still have no idea what a sql dba/developer does..

Also there a lot of c#...

If i am reading this correctly, you don't really need that where clause at all, as you are joining on the same clause which will restrict it there.

how about post...