How to let general user use xp_cmdshell?

Hi,

Is any way can let user (not admin role) use xp_cmdshell?

I write a SP and include xp_cmdshell to execute .exe file.

So I hope user can execute xp_cmdshell, too!

Any idea?

Thanks!

First, why would you want a user running xp_cmdshell? Talk about an open entry to your servers. Does your system admin know about this?

Second, not 100% but I think SP2 eliminated the ability for processes to run xp_cmdshell.