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 😉
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato