I can't help much because I'm not the one that sets up the VMs where I work, but I agree with the others.  I've seen what happens when such resources as...

p.s. And, as a fellow data professional, thank you VERY much for trying to protect people.  Now all you have to do is turn in the side-stepping beach creatures that...

You need to NOT...

Dude... do your own homework.  We're not the ones that need to...

In SSMS, you can click on the jobs folder of the Object Explorer (press the F8 key to get there if you don't already know how) and then press the F7...

Heh... I didn't see Drew's post because I had opened this thread and let it sit for a while.  So sorry for the double post with the same answer.

The error message was telling you exactly what is wrong... you weren't using the VALUES Table Valued Constructor correctly. 😉

create table ##Test ([Primary KW] varchar...

Just a word of caution from a crusty ol' DBA that's long in tooth and has many battle scars...

Adding RAM is always nice but that may not be...