Actually I think I might have found a way to replicate the problem.  It looks like it fails if the database parametrization is set to forced.

use master
GO
CREATE...

Thank you both.

After seeing your replies I got the feeling it might be SSMS related.  I started another instance of SSMS and as suspected... it worked.

I should have checked that...

• This reply was modified 5 months, 1 week ago by  PatLap.

Thank you guys for your help.  I did the following 3 tests and here are the results.

1) Original Call               -- CPU time...

The VM has 128GB and the SQl max mem is at 112GB.
Looks like it's the read time of the view that causes the problem.  I mean 12 minutes to...

@ScottPletcher
The server is not busy at all (24 cores).  Avg...

Got 78sec CPU time with COUNT and MAXDOP 1.
The view returns around 11 millions rows.  Is this normal on a 128GB system?
How long does it takes on one...

Just 38 user DBs and 60% of the memory used by 2 DBs. 
The Plan shows a hash match (30% for the function, 57% parralelism, 2% filter and then...

lkennedy76,

If it's a contained database there will not be any login therefore no entry in syslogins at the server level.

It has to be at table or view inside the database...

There might be better solutions but I think this would do the trick.

With CTEEducation AS

(Select emp_id, school, degree,

ROW_NUMBER() over (partition by emp_id order by edu_id) as ListId,

ROW_NUMBER()...

Nice! Thank you!

Found the solution.

sc config MsDtsServer obj= XXXX password= YYYY