Hi Gail

The linked servers are using an account with SysAdmin privileges.  It's a SQL-only login.
I'll alter the WHERE clause with your suggestion.

Unfortunately, the SP is...

Hi Eirikur
Here's the query (it's a basic SELECT for now):-
SELECT
    [ECAttendanceLocalID] = ra_m.AccountNumber
    ,PatientLocalID = hr_mrn.PrefixMedicalRecordNumber
    ,DiagnosisSeqID = COALESCE(dp.SortOrder,dp2.SortOrder)
    ,ProblemInstanceID = COALESCE(dp.ProblemInstanceID,dp2.[ProblemID])
    ,SnomedDesc = COALESCE(mpp_m.Name,mpp_m2.Name)
    ,UkProblemCondition...

Hi Gail

Here is the execution plan for the query.
I'll post the stored procedure one when it eventually finishes.

I can let you have the estimated one...

Hi all

Thought I'd resurrect this thread rather than starting a new one.

I've managed to find a script to download all the .rdl files and the associated...

I'd like something simple.....
I found a mis-spelling in a table name and I tried to use F2 to rename the field to the correct spelling.
As the table was...

No, we decided against AD groups as it would get complicated.
We've got a few cubes and users have different rights in each one.
There are 6 roles just for...

I hadn't thought of that so I'll have a look.

How would that work if we need to make changes to the cube and deploy without changing roles/members?

We've got Business Intelligence edition on 2012 but the data can span several months (although we could partition it by year).
I'll see what we can do with partitions. 
Thanks...

Thanks Gail

Another question (that's vaguely related to this...)

Let's say we have a virtual server that's got 64 cores in total and we want to install 4 instances of SQL...

Thanks Gail

I'll get onto our server team and ask them to sort the sockets/cores so we can use the lot.

Thanks both

Just one more question....
Will it be easier/better (in order to use all the cores) to:-
1) sort out the cores on the VM (and give each...

Hi Gail

Have you got a link to where I can find this infor for other versions please?

We're deliberately setting ours up as case-sensitive.
Our main application is case-sensitive for the databases and a few associated bits and pieces so we're making any new servers that use...

Problem solved!!!

There was nothing wrong with the connection string at all (apart from the tinyest of typos).

This line:-
CurrentDb.QueryDefs("DataBaseList").Connect = "ODBC;DRIVER=SQL Server;SERVER=" & server & ";DATABASE=Master"