Even I had a similiar kind of problem. Granting the proxy account, read/write permissions on temp directory did help. As mentioned my Steven, it was a bug in SP1 that...

Hi,

You can detach your database, and move your log file to new location. While attaching the database back again, you need to specify the new location of the log file,...

I am talking about 'Result in Text' in QA,

(As I want to store the output in a txt file).

Its not that I do or do not want to use those functions, the thing is they dont work.

I tried converting it to varchar,char, then ltrim/rtrim but somehow it does...