best approach is to  save it into local table   how to get the 5 minute...

No I don't need such granular data. But I can use a procedure to read all the data off all our clients, and store it in a table. I'll aggregate...

Thanks - I've already done cross database (scoped credentials etc) querying. I tried that on master, but it doesn't work there - I may ahve got the credentials etc wrong.

Looks...

Asked a colleague to look through things, and he spotted I'd failed to add

Value name: DisallowAdHocAccess

Data type: REG_DWORD

Radix: ...

Did move on from untrusted error to this one:-

Msg 7415, Level 16, State 1, Line 19

Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied. You must access this...

Done the following:-

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

GO

EXEC sp_configure 'ad hoc distributed queries', 1

RECONFIGURE

Changed inline process of [Microsoft.ACE.OLEDB.12.0] to yes

Added registry values for [Microsoft.ACE.OLEDB.12.0] to inlineprocess=1 and denyadhocprocess=0

In the end...

It appears there was a mal****ing in the DEV environment that meant the latest XSLT was not being used when exporting the XML file:pinch:. In despair I logged onto another...

The chart object takes your rows of data and displays them - the values are the columns that contain data - each one will be a sperate line\column etc. The...

Ok - is this in SSRS? Is your data arriving from a SQL Stored procedure? Is this a question about how to display the data, or how to calculate the...