I am a developer who has developed a large number of databases of varying complexity from scratch. I have certainly made mistakes but also some of the work I am...

Unfortunately, I find this to be the...

I find that automating much of a release stops "tinkering" i.e. people who think they know better making changes out of process (both automated and manual). For me, this is...

Have you tested this from PowerShell directly?

Have you run the SQLAgent task manually to ensure that it will work in the context of SQLAgent?

Have you tried writing a different SQLAgent...

I think that all you need for various levels of checking can be found here: http://www.powershellmagazine.com/2014/07/21/using-powershell-to-discover-information-about-your-microsoft-sql-servers/%5B/url%5D.

R Services looks very interesting, however, I also would be interested in information of the numbers using it. Is anyone? Not just looking at it or doing Proof Of Concept...

Have you tried the following?

$vsEnvVars = (dir Env:).Name -match "VS[0-9]{1,3}COMNTOOL"

$vsEnvVars = $vsEnvVars + "..\IDE\"

Can you show us how you are running it and any differences?

Looks about as floppy as the 3.5" disks (or Amstrad's 3" disks).

Genius. Now why didn't I think of that!!!

I am not sure what in your script isn't working. A little more detail please.

It is relatively easy to give little and often be it time or money. Probably both.

It isn't always the obvious charities that need support but also friends, neighbours, sports and/or...

You are most welcome.

ZZartin (5/13/2016)

---

Gary Varga (5/13/2016)

---

ZZartin (5/13/2016)

---

Gary Varga (5/13/2016)

---

Whenever dealing with permissions on a database or domain basis then it has always been easiest when using roles/groups. People move jobs but should...

ZZartin (5/13/2016)

---

Gary Varga (5/13/2016)

---

Whenever dealing with permissions on a database or domain basis then it has always been easiest when using roles/groups. People move jobs but should not retain permissions...