Start process remotely

Question

I would like to call exe(start process) on another computer from CLR procedure?
Is it possible?

Now, i have System.Diagnostics.Process but it copies exe locally and run it on sql server computer, not on remote one.

Answer 1

You can do that from Powershell.

http://stackoverflow.com/questions/18182690/how-to-start-remotely-process-in-powershell

--PRashanth

Answer 2

You could use WMI library subject to security considerations, but this is unsupported, assembly and dependencies must be UNSAFE, and your code may stop working in future releases. Search this forum for "WMI" to see some of the things folks have run into.

Cheers, Bob