All I did was research, noisily - I never actually did this.
I use powershell to run SQL, can’t remember if I actually used it to trigger SPs anywhere. Currently I have SPs updating external DBs using SQL jobs. I do have a few things like BPMs using streamwrite and text files pretending thereby to be databases…
But honestly more recently I’ve used UD tables, BAQs and REST to call BAQSvc with better results than anything. Plus .NET SQLClient seems to go nuckin futz on me
