Jim Mackenzie (2/20/2015)
Jeff Moden (2/20/2015)
Jim Mackenzie (2/20/2015)
However I can't help but think this would be better handled in Powershell?Do you happen to have a working example of such a thing? I'd love to see one that works from womb to tomb that can be called from SQL Server (not SSIS) without the use of xp_CmdShell.
Nope! haha. I'll have a play around when it's not 0410 in the morning and I'm awake due to being called out! Gotta love being the on call SQL Developer 🙂
Hi!
The Speed with which this needed to be rolled out was the single biggest factor in my choice of using XP_CMDSHELL. I am also not a fan of it and prefer to have it turned off.
The solution from my side would be to activte it at the beginning of the execution and deactivate it once the procedure is complete. On the side I will try to convert the whole Job to run in SQLCMD but first I Need to convince the Server admins that I Need the ability to use it.....
Regards,
Kev