opc.three (11/5/2012)
Jeff Moden (11/2/2012)
+1000 Orlando. Very bad use of xp_CmdShell in this case. And, if someone kills the spid that makes the call, it can't be killed unless you kill the spid that xp_CmdShell used first.It is great to have learned that your embrace of xp_cmdshell has limits Jeff. Our disagreement over its use in general is nuanced if nothing else 😉
Everything has its limits... even such disagreements. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.