Thanks steve

I've just double-checked and they are in separate file-groups.

I'm still concerned that they are different sizes and would like to tidy them up (if only, for nothing else, to...

I think they're in one file-group but I'd have to check on Monday to make sure.

Richard

Thanks Sue - I'll have a look.

Thanks Sue.  Looks like we're back to pen and paper (of some description) then.

We've found database diagrams really useful, especially when you've got complex databases, just to see how all...

It is frustrating that the diagramming tool built into SSMS hasn't evolved in any significant way since 2005. One thing you can do is print to diagrams to...

So there's no set of permissions I can give just to allow users to access the database diagrams.  Oh well.

Looks like we'll be exporting them and sticking them to the...

Hi all

I've managed to find somethinng that will allo wme to auto-change page at every refresh.

Now I've got a bit of an oddity.

I'm using sub-reports to display the different pages...

Hi both

Thanks for all your help.

I've logged as as the user I've created and it looks like (with a few tweaks to permissions) it's working as I wanted it to.

Now...

Thanks for that Sue.

Looks like I'll have to log in as that user and do my testing that way.

I would investigate the use of "FOR XML PATH".

We use it regularly to do exactly what you want to do (albeit with different values and for different reasons).

It's extremely fast...

This is the login details:-

USE [master]

GO

/* For security reasons the login is created disabled and with a random password. */

/****** Object: Login [ReportReader] Script Date: 08/04/2019...

Hi Lowell

I've just checked and I'm using the same setup as in your screenshot for the linked server.
The user I'm using does have access to that database.

Hi Lowell

Thanks for that.
That does (vaguely) make sense).

Now that's been sorted (and I know I've got to type the whole thing out), we come to...

It seemed to be random, but since I changed the job steps no-one's compalined about losing connections.
Looks like they were coming to see me randomly.

Hi Sue

I think the SChannel errors were a red-herring. and I think I've found the cause of the issue.

I ended up looking through the XMLA scripts...