Doh! I worked this out. I had to fully qualify the domain name in the URL to the report server.

Grrrr to the network guys.

Thats for local administration of the report server, if your logged into the Win2008 via remote desktop etc. I followed those steps a while back and dont have any...

Actually I found the answer in another post at another site somewhere. I'm led to believe that Microsoft have hardcoded the base64 encoding into sp_send_dbmail.

The problem I had was...

Some more examples on how to do this...

-- Setting default black/white for all measures.

SCOPE (

[Measures].AllMembers

);

BACK_COLOR(THIS) = VBAMDX.RGB(255,255,255);

FORE_COLOR(THIS)...

My mistake, I've worked out how this is done. Some examples on the web could probably have been written a bit better. Here is the format for the...

I grab lots of stuff from an AS400, but dont use a linked server. Install the client access driver on your server, create an ODBC connection and pump it...

I do a bit of this myself, and prefer to put a cursor around the information_schema.tables data.

Try a bit of this action:

select distinct table_name

from information_schema.tables

where table_type...

Resolved the problem, although it was a strange resolution.

All store codes in both the source and destination databases were at the same length. But rtrimming the store...

If you dont have a table containing the dates you are trying to find that lie between a date range, well... review your design.

You could do something like this though...

Your examples indicates your trying to update the documentID column in the document_image table with the value of the ID column from the document table, using a join via back_documentid....

Try this instead.

While 1 = 1

Begin

Begin Tran

...