Hi Sue

A bit more info.
I've found a lot of errors for SChannel that seem to be in pairs.

The first one is:-
A fatal alert was...

Thanks Sue

I'll have another dig around and see what I can find.

Hi Sue

There's not a lot of people on our DEV server so  I'm not sure.
Where would you recommend in the Windows logs?  I tried looking but nothing...

We do something similar but we don't set the database to OFFLINE.

We rename the database (F2 in SSMS) and put "zz" at the beginning of the database name.

Brilliant, thanks Brian.

That's saved a whole host of headaches.

Thanks for that.

Do you know if it will work on both multidimensional and tabular cubes (we have both)?
Also, will the rename empty the cube?  It doesn't look...

Does anyone know if this is possible?

I've found I can rename tabular cubes (go into Properties and then rename it).
If I generate a script from that, it...

We use synonyms to point between our test and production 3-rd party databases.
It helps when we deploy code between our test and production SQL boxes.

We've found it...

Completely forgot about doing it that way :blush:
That will probably solve my problem.

I fully agree that the vendor databases are usually less than perfect about naming conventions.

As I work in healthcare in the UK (not sure where other posters are...

Thanks folks

I'll add that permission and see what happens.

Hi Sue

These are subscriptions that are ruin on a timed schedule if that helps.

If you want them as just two pages (and assuming they are running from different datasets) you can put both datasets onto one report and, on the second tablix,  tick...